What is wrong with the following SQL statement? (Try to figure it out without running it):

SELECT vend_name
FROM Vendors
ORDER BY vend_name
WHERE vend_country = 'USA' AND vend_state = 'CA';

ORDER BY must came after any WHERE clause.

Comment on this FAQ