Write SQL queries for the Hotel System on MS Access. These queries should serve some business functions. You need to list all queries and a brief explanation of the purpose of each query. Output of all queries will also be included. You should write at least 3 single-table queries and at least 7 multi-table queries. The following 5 queries have to be designed. You can design any other 5 queries depending on your system.
Find the names of customer having at least stayed twice last 18 months.
Find the most valuable Customer (paying most) during last 24 months.
Find the most preferable/popular room type (Look at the reservation)?
What is the total revenue for the year 2012.
Find the average price of rooms where "smoking is allowed" and average price of rooms where "smoking is not allowed". (Hint: May need to use GROUP BY).
Which room type has been reserved most?
Any additional features that you may have included that enrich the project will also be included.
Waiting for your bids. Thanks.