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

What is the solution for this question (using sql queries)

Extracted text: 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, DateTo) Guest (GNum, Fname, Lname, Gender, DOB, City) Write the corresponding SQL queries for the below questions


Extracted text: 5. For each Hotel, List the total number of Rooms. 6. Write an SQL query to show all hotels along with the number of booking in there. 7. List the name of guests whose last name contains 'a'