Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a Query to provide all the customers who have a strike for Violating Max Capacity? Write a query to pull the employee records
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.
Step by Step Solution
★★★★★
3.47 Rating (160 Votes )
There are 3 Steps involved in it
Step: 1
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started