SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE cars (`Year` int, `Make` varchar(13), `Model` varchar(13), `Trim` varchar(11), `Mileage` int, `Color` varchar(6), `Price` int, `Vin` varchar(17), `Buyer` int) ; INSERT INTO cars (`Year`, `Make`, `Model`, `Trim`, `Mileage`, `Color`, `Price`, `Vin`, `Buyer`) VALUES (2010, 'FORD', 'TAURUS', 'SEL', 2572, 'White', 25600, '1FAHP2EW1AG163911', 0), (2008, 'JEEP', 'GR CHEROKEE', '4X4 LIMITED', 33860, 'White', 23700, '1J8HR582X8C117809', 1), (2007, 'JEEP', 'GR CHEROKEE', '4X4 LIMITED', 20155, 'White', 21900, '1J8HR58257C662217', 0), (2009, 'FORD', 'ESCAPE', '4X2 LIMITED', 11354, 'Green', 21100, '1FMCU04G69KB01856', 0), (2008, 'DODGE', 'CHARGER', 'RT', 34602, 'Yellow', 20250, '2B3LA53H38H185713', 0), (2008, 'LINCOLN', 'MKZ', 'NONE', 15772, 'Red', 20250, '3LNHM26T08R656808', 0), (2009, 'CHEVROLET', 'TRAILBLAZER', '4X4 LT', 35635, 'White', 19000, '1GNDT33SX92102535', 0), (2008, 'DODGE', 'RAM 1550', '4X4 QD', 68314, 'Green', 18600, '1D7HU18268J115846', 0), (2009, 'FORD', 'FUSION', 'SEL', 34595, 'Grey', 13950, '3FAHP08119R159916', 1), (2007, 'MERCURY', 'GRAND MARQUIS', 'GS', 19128, 'Gold', 11750, '2MEFM74VX7X617445', 0), (2006, 'CHEVROLET', 'COBALT', 'LT', 48021, 'White', 7375, '1G1AL55F167732362', 0), (2007, 'BUICK', 'LUCERNE', 'CX', 36225, 'Tan', 13050, '1G4HP57247U112723', 4), (2009, 'HYUNDAI', 'SONATA', '4C GLS', 30162, 'Tan', 11600, '5NPET46C89H532795', 0), (2007, 'JEEP', 'COMPASS', '4X4', 33296, 'Silver', 14050, '1J8FF47WX7D357711', 0), (2008, 'FORD', 'FOCUS', 'SES', 35668, 'Silver', 11350, '1FAHP33N68W238747', 0), (2001, 'FORD', 'EXPLORER', '4X4 SPORT', 61777, 'Blue', 5325, '1FMYU70E81UB70673', 0), (2008, 'MERCEDES-BENZ', 'ML320', 'NONE', 50543, 'Black', 35400, '4JGBB22E18A355249', 0), (2011, 'CADILLAC', 'STS', 'AWD', 14028, 'Black', 42800, '1G6DD67V280199562', 5), (1999, 'CADILLAC', 'ELDORADO', 'NONE', 58956, 'Black', 4350, '1G6EL12Y4XU607787', 0), (2008, 'LAMBORGHINI', 'GALLARDO', 'SPYDER', 4895, 'Black', 139900, 'ZHWGU22T28LA06389', 0) ; CREATE TABLE customers (`id` int, `name` varchar(20), `license` varchar(11)) ; INSERT INTO customers VALUES (1, 'Sally Phillips', 'NY774055434'), (2, 'Steven Smith', 'NY160423658'), (3, 'Gary Moore', 'MA942299072'), (4, 'Bill Barnes', 'CT896900826'), (5, 'Mary Andersen', 'NY132497102') ; select count(make) from cars; select AVG(mileage) from cars; select SUM(price) from cars where buyer > 0; select distinct(make) from cars order by make; select * from cars where trim like '4X4%'; update cars set color = 'taupe' where vin = '1FAHP2EW1AG163911'; select color, count(color) from cars group by color; select count(color) from cars where color = 'Black' union all select count(color) from cars where color = 'White' union all select count(color) from cars where color = 'Silver' group by color; select customers.name, customers.license, sum(price) from cars inner join customers on customers.id = cars.buyer group by customers.name, customers.license; create view luxury as select * from cars where make = 'Lincoln' or make = 'Cadillac';