Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1097. Game Play Analysis V
--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-03-02', 6), (2, 3, '2017-06-25', 1), (3, 1, '2016-03-01', 0), (3, 4, '2016-07-03', 5);
run
|
edit
|
history
|
help
0
pokemo
testo
Movie Rating SQL Analysis Project
Assignment 1(SET A)
Dashes in numbers
w3c sql data
2
Studco
Engenheiro
PostgreSQL Sandbox: General Resale