Which of the Following Statements Selects the Title and ProductionCo

Multiple Choice

Which of the following statements selects the Title and ProductionCo fields from records whose title begins with the word "The" followed by a space and zero or more characters,and then sorts the records in descending order by the ProductionCo field?

A) SELECT Title, ProductionCo FROM tblMovies WHERE Title LIKE 'The %' ORDER BY ProductionCo
B) SELECT Title, ProductionCo FROM tblMovies WHERE Title LIKE 'The %' ORDER BY ProductionCo DESC
C) SELECT Title, ProductionCo FROM tblMovies WHERE Title LIKE 'The *' ORDER BY ProductionCo DESC
D) SELECT Title, ProductionCo FROM tblMovies ORDER BY ProductionCo DESC