Henry Uses a Large Database to Generate Reports and Would

Essay

Henry uses a large database to generate reports and would like to make report delivery more efficient (faster). The reports derive from the following tables.
?
CANDY table, with these columns: PROD_ID, NAME, UNITS_SOLD_LAST_30DAYS
EMPLOYEE table, with these columns: EMP_ID, FIRST_NAME, LAST_NAME, OFFICE_PHONE
?
Write SQL commands to improve the efficiency of creating these two reports:
.Employee records alphabetized by last name, then first name
.Names of candy products listed by units sold in the last 30 days, in descending order