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
Select rows with no intersection on join table and check by date
sss
Query workaround in order to avoid IN Operator in WHERE Clause
as
postgresql: working days
to_char(now(), 'YYYYddd')
nasa2
jsonb handle
Islands demonstration
pokemo