P307 LQ4

a. SELECT REGISTRATION, MAKE, MODEL FROM CARS;

b. SELECT * FROM CARS WHERE SUNROOF="NO";

c. SELECT REGISTRATION, MAKE, PRICE FROM CARS WHERE MAKE = "FORD" AND PRICE < 250000;

d. SELECT REGISTRATION, SUNROOF, MILEAGE FROM CARS WHERE SUNROOF = "YES" ORDER BY MILEAGE;

e. SELECT MAKE, MODEL, COLOUR, ENGINE_SIZE FROM CARS WHERE COLOUR = " RED" OR COLOUR = "BLUE" ORDER BY ENGINE_SIZE SESC;

f. SELECT REGISTRATION, MODEL, PRICE FROM CARS ORDER BY MAKE, MODEL;

g. SELECT * FROM CARS WHERE PRICE BETWEEN 200000 AND 400000;

h. SELECT COUNT(*) FROM CARS WHERE SUNROOF = "NO";