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)?