Our site uses cookies. Some of the cookies we use are essential for parts of the site to operate and have already been set. You may delete and block all cookies from this site, but parts of the site will not work. To find out more about cookies on this website, see our Cookie Policy

Your browser does not appear to have javascript enabled. This page needs JavaScript activated to work properly. Please enable javascript or choose a different browser (Chrome or Safari)

This test is run by .
Note that your final mark will not be saved in the system.

6. Databases Reorder

Target Level

Running Total

Attempt

1 of 3

Drag and drop the boxes into the correct order.

Sort the following SQL queries into order based on how many records they would yield from the table, from the fewest records to the most.

SELECT * FROM cars WHERE Engine >= 1 AND Seats >= 2
SELECT * FROM cars WHERE Seats > 2 OR Engine < 1.6
SELECT * FROM cars WHERE Doors = 3
SELECT * FROM cars WHERE Make LIKE '%a%'
SELECT * FROM cars WHERE Seats > 2
SELECT * FROM cars WHERE Engine < 1.6 AND Doors = 5
SELECT * FROM cars WHERE Model LIKE '%X%'
SELECT * FROM cars WHERE Seats = 4 and Engine > 1.0

This is your 1^st attempt! The marking algorithm gives more marks for getting the right order first time.

Pass Mark

70%