Question: Write the following SQL queries for the Hotel Management System attached. Each students have to answer only 3 of the questions below. The question assignments
Write the following SQL queries for the Hotel Management System attached. Each students have to answer only 3 of the questions below. The question assignments are given below for each student individually. Assume that the current Date is December 15, 2020 while writing the SQL queries.Please do it on Microsoft Access.
1.Find the person paying late fee most during last 6 months
2.What is the average number of person staying per room during last 2 months?
3.Which customers have checked out late during last month?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
