Question

Which query will return a list of all corn farms that have made more than $4 million, ordered by the greatest number of years in business to the fewest number of years in business?



123456
SELECT *
FROM `FarmsDirectory`
WHERE Crop = 'Corn'
AND Revenue > 4000000
ORDER BY Years_in_business ASC;




123456
SELECT *
FROM `FarmsDirectory`
WHERE Crop = 'Corn'
AND Revenue > 4000000
ORDER BY Years_in_business DESC;




123456
SELECT *
FROM `FarmsDirectory`
WHERE Crop = 'Corn'
WHERE Revenue > 4000000
ORDER BY Years_in_business DESC;




12345

Answer 1

The second query:

SELECT *
FROM `FarmsDirectory`
WHERE Crop = 'Corn'
AND Revenue > 4000000
ORDER BY Years_in_business DESC;

Reason: it filters for corn farms with Revenue > 4,000,000 and orders by Years_in_business in descending order (greatest to fewest). The first uses ASC (wrong direction) and the third incorrectly uses two WHERE clauses.