Problem: Write queries to answer the following questions. Note some questions, you may have to create two queries - one to calculate an invoice total and the second to answer the question asked.
Q1) How many kinds of inventory items does S & S sell?
Q2) How many sales were made during October?
Q3) What were total sales in October?
Q4) What was the average amount of a sales transaction?
Q5) Which salesperson made the largest sale?
Q6) How many units of each product were sold?
Q7) Which product was sold the most?
Attachment:- Kinds of inventory items.rar