Question: Write the following SQL queries for the System. (codes) 1. Find the names of person having at least 3 stays during last 6 months. 2.

Write the following SQL queries for the System. (codes)

1. Find the names of person having at least 3 stays during last 6 months.

2. Find the person paying most during last 6 months.

6. Which room types are not available on December 26th and 27th, 2020?

7. What is the average number of person staying per room during last 2 months?

Assume that the current Date is December 15, 2020 while writing the SQL queries.

AVAILABILITY PREFERENCES Oo PREFERENCES CID TypeID Date NumberOfAvailableRooms 18 oo 18 RESERVATION Reservation Number Reservation CancellationDate CustomerlD TypeID Reservation Date CheckInDate CheckOutDate EstimatedPrice DiscountRate NumberOfAdults NumberOfChildren CUSTOMER Customer FirstName Middle Surname StreetAdress City 11 81 ROOM_TYPE TypeID Description Quantity DailyPrice ZIP RESERVATION_HISTORY Reservation Number CustomerID RoomType Reservation Date CheckInDate EstimatedCheckOutDate ActualCheckOutDate RoomNo MinibarConsumption LateFee TotalFee NumberOfChildren 18 ROOM PhoneNumber DOB Gender E-Mail IsMember Preferred-CC-No 00 RoomNumber TypeID Floor BedCapacity IsSmooking Room IsAvailable

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write the following SQL queries for the Bookstore / Library Management System on MS Access. You need to include SQL commands and outputs of all queries in the hardcopy of the submission. Softcopy has...

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...

Write the following SQL queries for a Hospital system on MSAccess or MySQL . Each student is expected to write the queries that answer the questions below. The SQL codes that can build the database...

Write the following SQL queries for a Airline system on MSAccess or MySQL. Each student is supposed to answer all the questions below. 1. Find the names of person who has flown at least 2 times...

Write the following SQL queries for the Hotel Management System attached. Each students have to answer only 3 of the questions below. Assume that the current Date is December 15, 2020 while writing...

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...

The following model was fitted to a sample of 30 families in order to explain household milk consumption: yi = b0 + b1x1i + b2x2i + ei where yi = milk consumption, in quarts per week x1i = weekly...

6. If the projected NPV cashflow is positive, does this guarantee that the new company strategy will work? a. No, the projections could have been incorrectly calculatedb. No, the projections could...

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

If you were reading another persons profile as a prospective partner, how carefully would you critique it?

Consider someone with whom you share a very close relationship. In what ways are you similar to this person? Are those similarities what attracted you in the first place?

A The Quran forbids the consumption of alcohol. Does the absence affect communication between non-Muslim drinkers and Muslim nondrinkers?