Question

1. Sort the AccountReps table first in ascending order by the name of the account rep and then in descending order by total sales so Bao can quickly identify the top sellers for each rep.

Answer 1

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.