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

4-TOTALPAY BY JOBTITLE: answers the question, "How much total salaries are paid to each job title (e.g., Business Analyst, Business Consultant)?" Include fields: JOBTITLE and a calculated field called TOTALPAY defined as HOURS*PAYBYHOUR.

5-TOTALPAY BY PAYBAND: answers the question, "How much total salaries are paid for each pay band?" Include fields: PAYBAND and a calculated field called TOTALPAY defined as HOURS*PAYBYHOUR.

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

And I am not 100% sure these relationships are correct.

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