Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1127. User Purchase Platform
--PostgreSQL 9.6 --'\\' is a delimiter drop table if exists Spending; Create table Spending ("user_id" int, "spend_date" date, "platform" varchar(255), "amount" int); insert into Spending (user_id, spend_date, platform, amount) values (1, '2019-07-01', 'mobile', 100), (1, '2019-07-01', 'desktop', 100), (2, '2019-07-01', 'mobile', 100), (2, '2019-07-02', 'mobile', 100), (3, '2019-07-01', 'desktop', 100), (3, '2019-07-02', 'desktop', 100);
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
pokemo
Demande complète
Recursive inefficiency
postgresql: working days
SQL Movie-Rating Query Exercises
SQL3
JsonB Query
PostgreSQL aggregate JSON recordset keys by row
pgsql trigger 01 - Ovocie
a
Please log in to post a comment.