Creating stored procedure in sql

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

You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.