Run Code
|
API
|
Code Wall
|
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
Cilinica_X
Assignment 1(SET A)
pokemo
1
Timestamps in PostgreSQL
sss
Food Delivery Website SQL Analysis
3c
Pedido_Insert_Delete
simple add function on sql