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
2
postgresql example hierarchy with addresses
Pedido_Insert_Delete
Demo
Query integer in text field - Seemingly doesn't work as expected
Select rows only with values separated by a given interval from other ...
MovieRating SQL
Returning IDs with exactly 3 consecutive months of invoice_amt >2000
user
Full text search