Use a query to compute the average purchase amount per product made by each customer.
Answer to relevant QuestionsWrite a query to produce the number of invoices and the total purchase amounts by customer, using the output shown in Figure P7.35 as your guide.Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by firstname.Write a query to display the employee number, last name, e-mail address, title, and department name of each employee whose job title ends in the word “ASSOCIATE.” Sort the output by department name and employeetitle.What three join types are included in the OUTER JOIN classification? What is a stored procedure, and why is it particularly useful? Give an example.
Post your question