Henry uses a large database to generate reports and would li…
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_30DAYSEMPLOYEE table, with these columns: EMP_ID, FIRST_NAME, LAST_NAME, OFFICE_PHONEWrite SQL commands to improve the efficiency of creating these two reports:Employee records alphabetized by last name, then first nameNames of candy products listed by units sold in the last 30 days, in descending order