Northwind would like to know the total compensation paid to each HOURLY employee in 2020. List the employee's last name, Commission Paid, Estimated Salary (see #2 above) and the Total Compensation (Commission Paid + Estimated Salar;). Commission is eamed on the pre-discount total of all orders completed by that employee multiplied by the commission rate of 5%. Use appropriate column names. Sort in descending order by Total Compensation (Hints. This query will
require four tables. Use a subquery in the SELECT clause in order to get 'Total Compensation'.
When referting to column aliases in the ORDER BY clause, use tick marks instead of quotation