Using the classicmodels database, produce a sales summary using GROUP BY of the following fields: productName, firstName (employees), lastName (employees) and quantityOrdered. Correctly done, you should produce a list with quantityOrdered similar to:

1836 Citroen Roadhog, John, Smith, 987 1836 Citroen Roadhog, Jane, Mansfield, 582 1836 Citroen Roadhog, Jack, Loserman, 2 ...etc.

Your goal is to identify the salesperson selling the most of whatever item you're given to search.

BTW, Citroen didn't make the Roadhog in 1836. Come to think of it, they never made a car called the Roadhog. Come to think of it, nobody made cars until 1885. Just saying.

Hints: You're using a GROUP BY so you automatically know you need a SQL aggregator function. To put the list in descending order, what phrase would you use to do it?

Armed with the above bountiful information (that's practically written your query for you), identify the salesperson who sold the most:

'1957 Corvette Convertible'