Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
hw
--PostgreSQL 9.5 --'\\' is a delimiter Create TABLE Product( maker CHAR(10), model CHAR(10), year INT ); Create TABLE Car(model CHAR(10), city INT, highway INT, style CHAR(10), passengers INT, trunk FLOAT, msrp FLOAT); Create TABLE Pickup(model CHAR(10), city INT, highway INT, passengers INT, cargo INT, towing INT, msrp FLOAT); Create TABLE EV(model CHAR(10), range INT, battery FLOAT, passengers INT, msrp FLOAT); /* Create few records in this table */ INSERT INTO Car VALUES('civic1',25,32,'a',2,20.1,32); INSERT INTO Car VALUES('civic2',20,40,'a',2,20.1,32); INSERT INTO Car VALUES('civic3',21,40,'a',2,20.1,32); INSERT INTO Product VALUES('honda', 'civic1', 2001); INSERT INTO Product VALUES('honda', 'civic2', 2001); INSERT INTO Product VALUES('honda', 'civic3', 2001); Select * from CAR;
run
|
edit
|
history
|
help
0
75 95
Attributvariation 2
Select rows with no intersection on join table and check by date
ds
Mandelbrot
Postgres Trigger
Movie Rating SQL Analysis Project
SQL social network practice by Han Wang 20200720
Select the latest id from last week from each different contact without repeating barcodes .....
E-commerce Website SQL Analysis