Database

Problem 4: SQL Queries (30 pts) Consider the following relations. The primary keys are underlined while the foreign keys are in italic. Hotel (HNum, Hname, Location) Room (RNum, HNum, Type, View, Price) Booking (ID, HNum, GHum, RNum, DateFrom, Date To) Guest (GNum, Fname, Lname, Gender, DOB, City) Write the corresponding SQL queries for the below questions 6. Write an SQL query to show all hotels along with the number of booking in there. Page 7 of 8 CSCI335 Fina 2021 - 2022 7. List the name of guests whose last name contains 'a' 8. List the names of hotels who has no booking in them 9. Find the room number with no booking. 10. Find the highest price and average price of room