This is my er diagram, I need help getting an idea on how to write a query for the two statements listed below.

1. NOTE[THIS ONE SHOULD BE A PROCEDURE OR FUNCTION] SpecificHotelReport: Input: hotelID, start-date, end-date. Print (for the given time interval):

Income by room type

Income of services, by service type

Total income from all sources.

2. Total income from all sources of all hotels. Totals must be printed by month, and for each month by room type, service type. Include discounts.

Rooms oom Number Room Type Rates Room location Customer ID Hotel_ID Hotels Services Service ID Service_name Service cost Hotel ID

Room charge Misc charges Credit card No Payment Date Customer ID Reservation_Number stomer ID Check in date Check out date Status Guest_fname Guest Iname Room Type Number of guests Reservation date Hotel ID Service ID Room Number Hotel ID Customer Customer ID Last Name Phone number First Name City State Zip code