first of all, i must warn you, stick to either SQL Server syntax (e.g. square brackets around identifier names) or MySQL syntax (e.g. LIMIT), because if you mix them, you’ll get errors
SELECT something
, anything
, just_please_god_not_the_dreaded_evil_select_star
FROM Games
WHERE genre='Driving'
ORDER
BY CASE WHEN console='PlayStation'
THEN 'Humpty'
ELSE 'Dumpty'
END DESC LIMIT 0,5