Run Code
|
API
|
Code Wall
|
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
Final test
finaleHFEIZFIDSHI
How i can get the difference of closest two date in two table join in postgresql
FInale 38474297439
pokemo
loggin_trigger-audit
jsonb handle
Movie Rating SQL Analysis Project
MovieRating SQL
Inner Join