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
Pivot the Hard Way..
SQL Practice Sample: Movie Database
tegs and users
Limit & union
Final 2
Movie Rating SQL Analysis Project
generate-data-combinations-for-a-column-dynamically-based-on-another-column-sql-postgresql
Black Wall
Stack
Current time/date, timezone