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

3-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.

6-TOTALSALARIES: answers the question, "What is the total amount salaries paid"?

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

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

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 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