Please help us with the queries

College of Computer Science Department of Computer Information System CIS 321: Database Concepts & Design hotelio rooio type price 6578 1288 aly 300 1- How many hotels are there? 2- What is the average price of a room? 3- What is the total income from bookings for "Marriott" hotel today? 4- What is the average number of bookings for each hotel in August? 5- What is the lost income from unoccupied rooms at each hotel today? 6- What is the most commonly booked room type for each hotel in Riyadh? 7- Create a function for each of the queries specified in exercises: 1, 2, and 3. 8- Create a stored procedure for each of the queries specified in exercises: 4, 5, and 6 College of Computer Science Department of Computer Information System CIS 321: Database Concepts & Design hotelio rooio type price 6578 1288 aly 300 1- How many hotels are there? 2- What is the average price of a room? 3- What is the total income from bookings for "Marriott" hotel today? 4- What is the average number of bookings for each hotel in August? 5- What is the lost income from unoccupied rooms at each hotel today? 6- What is the most commonly booked room type for each hotel in Riyadh? 7- Create a function for each of the queries specified in exercises: 1, 2, and 3. 8- Create a stored procedure for each of the queries specified in exercises: 4, 5, and 6