Write SQL queries for the following: The hotel database has the following schema

ID: 3867024 • Letter: W

Question

Write SQL queries for the following:

The hotel database has the following schema:

HOTEL(hnumber, hname, address)

Primary key: {hnumber}

ROOM(rnumber, hnumber, type, price_night)

Primary key: {rnumber, hnumber}

Foreign key: {hnumber} refernces primary key of HOTEL

GUEST(gnumber, gname, address)

Primary key: {gnumber}

BOOKING(hnumber, gnumber, arrive_date, left_date, rnumber)

Primary key: {hnumber, gnumber, rnumber}

Foreign key 1: {gnumber} references primary key of GUEST

Foreign key 2: {rnumber, hnumber} references primary key of ROOM

Write the following queries:

1)What is the price difference between the cheapest and most expensive room in the BIG HOTEL (BIG HOTEL is a hotel name)?

2)Find names of all guests that have never stayed in the NEW HOTEL (NEW HOTEL is a hotel name)?

1. select max(price_night) - min(price_night) FROM ROOM r, HOTEL h where r.hnumber=h.hnumber and h.hname = 'BIG HOTEL'

2. select g.gname from GUEST g, BOOKING b, HOTEL h where g.gnumber=b.gnumber and b.hnumber = h.hnumber and h.hname is not like 'BIG HOTEL'

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.