Write a Query to provide all the customers who have a strike for Violating Max Capacity?...

Transcribed Image Text:

Write a Query to provide all the customers who have a strike for "Violating Max Capacity"? Write a query to pull the employee records for the employee(s) that have the highest number of maintenance jobs completed? Write a query to pull the facility who had the most recent maintenance completed. Then, build upon that query to find out who was the last customer to book that facility. Query results should show the facility, customer, maintenance date, and last reservation date. Write a query to provide a listing of each facility with the amount of maintenance, number of bookings, and category name. Write a query to identify the most expensive booking. Provide the name of the facility, customer, location, reservation date, and cost of the booking in the query results. Based upon the answer from question 12, write a query to identify how many total bookings the customer from question 12 has made in total in the past. Based upon the answer from question 12, write a query to provide the total amount of money the facility has made. Output should provide the facility name and total amount of money. Write a query to list out the customer details as well as the total amount of money they have spent on bookings. Write a query to take the output from question 16 and add a sub-select into your select portion of your query to add a column to calculate the average booking per customer. Write a Query to provide all the customers who have a strike for "Violating Max Capacity"? Write a query to pull the employee records for the employee(s) that have the highest number of maintenance jobs completed? Write a query to pull the facility who had the most recent maintenance completed. Then, build upon that query to find out who was the last customer to book that facility. Query results should show the facility, customer, maintenance date, and last reservation date. Write a query to provide a listing of each facility with the amount of maintenance, number of bookings, and category name. Write a query to identify the most expensive booking. Provide the name of the facility, customer, location, reservation date, and cost of the booking in the query results. Based upon the answer from question 12, write a query to identify how many total bookings the customer from question 12 has made in total in the past. Based upon the answer from question 12, write a query to provide the total amount of money the facility has made. Output should provide the facility name and total amount of money. Write a query to list out the customer details as well as the total amount of money they have spent on bookings. Write a query to take the output from question 16 and add a sub-select into your select portion of your query to add a column to calculate the average booking per customer.

Answer rating: 100% (QA)

The SQL queries listed below can handle each of your requests 1 Enumerate every client who has received a strike for Violating Max Capacity SQL query ... View the full answer