1. Create queries to answer the following questions:
   1. What was the average amount billed per transaction? (This query should return a single number.)
   2. What was the average amount billed for each service type? (Sort descending by Description)
   3. What was the average amount billed per client type? (This query should return a single number per client type.)
2. Create the following report:
   1. Amount Billed by Client. Include the following in your report: Client Name, Transaction Number, Billing Date, Due Date (assuming due date is 10 days after the billing date), and the Amount Billed. Total the Amount Billed for each client and include a grand total. Group by Client and sort by Transaction Number.

 

Transcribed Image Text:

Service ServiD Description Rate Billing TransNo BillingDate ClientID ServID HoursBilled Client ClientID ClientTypeID ClientName Address City ClientType * ClientTypeID ClientTypeDesc Service ServiD Description Rate Billing TransNo BillingDate ClientID ServID HoursBilled Client ClientID ClientTypeID ClientName Address City ClientType * ClientTypeID ClientTypeDesc

Answer rating: 100% (QA)

What was the average amount billed per transaction select avgSRate as AVGRATE from Billing as B inner join Service as S on BServID SServID group by B ... View the full answer