SQLize Online / PHPize Online

A A A
Share   Donate   Blog   Popular
Copy Format Clear
CREATE TABLE customers( Buyer INT (50) , Name VARCHAR (50) , Drivers_License VARCHAR (50), PRIMARY KEY(Buyer)); INSERT INTO customers VALUES(1,'Sally Phillips','NY774055434'); INSERT INTO customers VALUES(2,'Steven Smith','NY160423658'); INSERT INTO customers VALUES(3,'Gary Moore','MA942299072'); INSERT INTO customers VALUES(4,'Bill Barnes','CT896900826'); INSERT INTO customers VALUES(5,'Mary Anderson','NY132497102'); CREATE TABLE vehicles( Year VARCHAR (50), Make VARCHAR (50), Model VARCHAR(50), Trim VARCHAR (50) , Mileage INT (50) , Color VARCHAR (50) , PRICE INT (50) , VIN VARCHAR (50), Buyer INT(50) ); INSERT INTO vehicles VALUES('2010','FORD','TAURUS','SEL',2572,'White',25600,'1FAHP2EW1AG163911',NULL); INSERT INTO vehicles VALUES('2008', 'JEEP', 'GR CHEROKEE ', '4X4 LIMITED ', 33860, 'White' , 23700, '1J8HR582X8C117809', 1); INSERT INTO vehicles VALUES('2007' ,'JEEP', 'GR CHEROKEE', '4X4 LIMITED ', 20155, 'White', 21900, '1J8HR58257C662217', NULL); INSERT INTO vehicles VALUES('2009', 'FORD', 'ESCAPE', '4X2 LIMITED ',11354, 'Green', 21100, '1FMCU04669KB01856', NULL); INSERT INTO vehicles VALUES('2008', 'DODGE', 'CHARGER', 'R/T', 34602, 'Yellow', 20250, '2B3LA53H38H185713', NULL ); INSERT INTO vehicles VALUES('2008', 'LINCOLN', 'MKZ','',15772, 'Red', 20250, '3LNHM26T08R656808', NULL ); INSERT INTO vehicles VALUES('2009', 'CHEVROLET', 'TRAILBLAZER', '4X4 LT ', 35635, 'White', 19000, '16NDT33SX92102535', NULL); INSERT INTO vehicles VALUES('2008', 'DODGE', 'RAM 1550', '4X4 QD', 68314, 'Green', 18600, '1D7HU182683115846', NULL); INSERT INTO vehicles VALUES('2009', 'FORD', 'FUSION', 'SEL', 34595, 'Grey', 13950, '3FAHP08119R159916', 1 ); INSERT INTO vehicles VALUES('2007 ', 'MERCURY', 'GRAND MARQUIS ', 'GS', 19128, 'Gold', 11750, '2MEFM74VX7X617445', NULL); INSERT INTO vehicles VALUES(' 2006', 'CHEVROLET', 'COBALT', 'LT', 48021, 'White', 7375, '161AL55F167732362', NULL); INSERT INTO vehicles VALUES('2007', 'BUICK', 'LUCERNE', 'CX', 36225, 'Tan', 13050, '164HP572470112723', 4); INSERT INTO vehicles VALUES('2009', 'HYUNDAI', 'SONATA', '4C GLS', 30162, 'Tan', 11600, '5NPET46C89H532795', NULL); INSERT INTO vehicles VALUES('2007', 'JEEP', 'COMPASS', '4X4', 33296, 'Silver', 14050, '1J8FF47WX7D357711',NULL); INSERT INTO vehicles VALUES('2008', 'FORD', 'FOCUS', 'SES', 35668, 'Silver', 11350, '1FAHP33N68W238747',NULL); INSERT INTO vehicles VALUES('2001', 'FORD', 'EXPLORER','4X4 SPORT', 61777, 'Blue', 5325, '1FMYU70E81UB70673' , NULL); INSERT INTO vehicles VALUES('2008', 'MERCEDES-BENZ', 'ML320', '',50543, 'Black', 35400, '4JGBB22E18A355249',NULL); INSERT INTO vehicles VALUES('2011', 'CADILLAC', 'STS', 'AWD', 14028, 'Black', 42800, '166DD67V280199562', 5); INSERT INTO vehicles VALUES('1999', 'CADILLAC', 'ELDORADO','',58956, 'Black', 4350, '1G6EL12Y4XU607787',NULL); INSERT INTO vehicles VALUES('2008 ', 'LAMBORGHINI', 'GALLARDO', 'SPYDER', 4895, 'Black', 139900, 'ZHWGU22T28LA06389', NULL); SELECT COUNT(Color) FROM vehicles WHERE Color='White'; SELECT TOP 3 Trim FROM vehicles ORDER BY Make DESC;
Stuck with a problem? Need help? Ask professionals on our Telegram channel!
Join the channel
Your quersion is posted.
Join our Telegram channel and get answers.
Send
Copy