I need help with following questions:
Design the stored procedure to answer the following question:  What is the utilization of the room for a one week period. The procedure will return a list of the rooms showing how many of each service (procedure or consultation) with the total time used for each plus a grand total for the room starting at the specified search_start_date for 7 days.
Be sure to handle errors gracefully.  Errors may include invalid room or date range.

Specification for the stored procedure:

Room_utilization (search_start_date)

Submit the solution that you have designed and discuss its merits as part of the submission. This means that there will be two files, the sql code and a document discussing it.

I will attach the sql file

Thank you