Problem Statement

Sorting Employees by Company Ascending and Name Descending The table WORKS (EMPLOYEE_NAME, COMPANYNAME, SALARY) records which company each employee works for. Which SQL query lists the names and company names of all employees, sorted in ascending order of company name and, within each company, in descending order of employee name?