Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Game Play Analysis (511,512,534,550)
--PostgreSQL 9.6 --'\\' is a delimiter Create table Activity ("player_id" int, "device_id" int, "event_date" date, "games_played" int); insert into Activity("player_id", "device_id", "event_date", "games_played") values (1, 2, '2016-03-01', 5), (1, 2, '2016-05-02', 6), (1, 3, '2017-06-25', 1), (3, 1, '2016-03-02', 0), (3, 4, '2018-07-03', 5);
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
1075-1077 Project Analysis
LeetCode 262
Ecommerce Website Analysis by SQL
xD
1097. Game Play Analysis V
project 1
loggin_trigger-audit
book suggestion
Leetcode 569. Median Employee Salary
ECommerce Website SQL Analysis by Iggy Zhao
Please log in to post a comment.