SQL Queries Homework, Create the following queries using the names shown (i.e., including the leading number 1, 2, etc.):

1. TOTALPAY BY EMPLOYEE: answers the question, "What are the salaries paid to each employee?" Include fields: EMPLOYEEID, DEPARTMENT, WORKDATE, WORKCODE, WORKCODES. WORKNAME, HOURS, PAYBYHOUR, and a calculated field called TOTALPAY defined as HOURS*PAYBYHOUR.

2. TOTALSALARIES: answers the question, "What is the total amount salaries paid"?

Please tell me the specific content that needs to be input.

Thank you so much.

Search... Tables E EMPLOYEES 3 PAYBANDS E TIMESHEETS EMPLOYEES PAYBANDS WORKCODES WORKCODES PAYBAND ZONE PAYBYHOUR JOBTITLE TIMESHEETS 1 Employeeld 1 WorkDate 1 WorkCode Hours 1 WorkCode WorkName Description Employeeld LastName FirstName JobTitle PAYBAND ZONE Department Street City State Zip Code