Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Product Sales Analysis I - III
--PostgreSQL 9.6 --'\\' is a delimiter drop table if exists Sales; drop table if exists Product; Create table Sales("sale_id" int, "product_id" int, "year" int, "quantity" int, "price" int); Create table Product("product_id" int, "product_name" varchar(255)); insert into Sales ("sale_id", "product_id", "year", "quantity", "price") values (1, 100, 2008, 10, 5000), (2, 100, 2009, 12, 5000), (7, 200, 2011, 15, 9000); insert into Product ("product_id", "product_name") values (100, 'Nokia'), (200, 'Apple'), (300, 'Samsung');
run
|
edit
|
history
|
help
0
FINALE fdjfnkds
Leetcode 571 Find Median Given Frequency of Numbers & 614 Second Degree Follower
array comparison
base de datos api teclab
sss
Ultima Clase
tegs and users
Weekly Average Starting on Different Days
pgsql trigger 01 - Ovocie
1