In this question we have to sort the accountreps table first in the ascending order by the name
and then descending order by total sales
so that it can be quickly identified by Bao the top sellers for each rep.
The SQL code
SELECT * FROM AccountReps
ORDER BY name ASC,
Sales DESC;
To sort we will select ORDER BY clause . For ascending order we will use ASC for names and for descending order we will use DESC for sales.
If you have any doubt you can comment.
like if you got your answer.
Get Answers For Free
Most questions answered within 1 hours.