List the number of rooms in each hotel

Assignment Help Database Management System

Reference no: EM131872748

Using Access and the hotel spring 18, code the SQL for the following queries. Do not change any of the data in the database. Name the queries Query 1 through Query 6. Rename this database to include your last name (e.g., hotel spring 18Fuller) and submit via blackboard.

Query 1: List the number of rooms in each hotel. You should display the name of the hotel and the count. Only display the hotels that have at least 5 rooms.

Query 2:Which guests (by first and last name and guest no) have booked rooms at the Hyatt for more than $90?

Q3: Which hotel (by name) has the highest rate booked?

Q4: Which hotels do not have rooms with standard rates less than $150

Q5: for each guest(by guest no) , which is the minimum rate at which they have booked rooms?

Q6: Which hotels (by name) have been booked by guestno 8? You must use a subquery for this question.

Attachment:- Hotel Database.rar

Reference no: EM131872748

Questions Cloud

Two models in the court system : The two models in the court system are the crime control model and the due process models. Explain the philosophies of each model and what each model represents

Result of abolishing the juvenile justice system : What Do you think would be the result of abolishing the juvenile justice system and having adult courts deal with all youthful offenders.

To what extent do you think failure should be tolerated : To what extent do you think failure should be tolerated when experimenting with business analytics and innovation strategies?

What is a disaster recovery center : 1. What is a disaster recovery center? 2. What are the three main groupings of disaster response performed by the UN OCHA and give examples?

List the number of rooms in each hotel : List the number of rooms in each hotel. You should display the name of the hotel and the count. Only display the hotels that have at least 5 rooms.

Determining the adversarial model : Based on an "adversarial model" and focuses heavily on the rights of the accused. The adversary system seeks to protect individual rights

How are you going to meet the demand : If the standard time for a part is 2.684 minutes per part and your factory works 24/7 five days a week How many parts can you make in a week?

Prepare all the journal entries for sallly : Carl Leasing, Inc. agrees to lease medical equipment to Sally, Inc. on January 1, 2012. Prepare all the journal entries for Sally, Inc. for 2012

Find several kilos of cocaine on poker dining room : The officers enter Poker's home anyway and although they do not find Gashat, they find several kilos of cocaine on Poker's dining room table.

User Account

All Pages