SERVICE_ID PROPERTY_ID CATEGORY_NUMBER OFFICE_ID DESCRIPTION STATUS EST_HOURS SPENT_HOURS NEXT_SERVICE_DATE 1 11 2 2 The second bedroom upstairs is not heating up at night. Problem has been confirmed. central heating engineer has been scheduled. 2 1 2019-11-01 2 1 4 1 A new strip light is needed for the kitchen. Scheduled 1 0 2019-10-02 3 6 5 1 The bathroom door does not close properly. Service rep has confirmed issue. Scheduled to be refitted. 3 1 2019-11-09 4 2 4 1 New outlet has been requested for the first upstairs bedroom. (There is currently no outlet). Scheduled 1 0 2019-10-02 5 8 3 2 New paint job requested for the common area (lounge). Open 10 0 NULL 6 4 1 1 Shower is dripping when not in use. Problem confirmed. Plumber has been scheduled. 4 2 2019-10-07 7 2 2 1 Heating unit in the entrance smells like it’s burning. Service rep confirmed the issue to be dust in the heating unit. To be cleaned. 1 0 2019-10-09 8 9 1 2 Kitchen sink does not drain properly. Problem confirmed. Plumber scheduled. 6 2 2019-11-12 9 12 6 2 New sofa requested. Open 2 0 NULL StayWell’s finance department wants to calculate the number of spent hours on each category of services. They require this data to calculate the payments to each service team. You need to collect this information from all the service requests in the database. Output two columns, the category number as CATEGORY_NUMBER, and the spent hours as HOURS_SPENT. Calculate the number of hours spent on each category of services. Expected Results CATEGORY_NUMBER HOURS_SPENT 2 1 4 0 5 1 3 0 1 4 6 0 I need the SQL Command

Q: The following code would include: CREATE OR REPLACE TRIGGER TRG_LINE_PROD AFTER INSERT ON LINE…

A: Dear Student, The answer to your question with required explanation is given below -

Q: 1. In the Orderltems table, display a count of the number of products with a prod_id of BR01.…

A: To display the count of products with a prod_id of BR01 from the OrderItems table with the given…

Q: Selena Gomezz has ventured into e-commerce and her website has a lot of products - so many that her…

A: The solution to the given question is: It is important for any business to focus on customer…

Q: Payor: You are working for an insurance company and you need a database to help track your quality…

A: Business Rule : A business rule characterizes or compels some part of business and consistently sets…

Q: Write, but do not execute, the commands for Task 10 through Task 12. Task 10: List all the tables…

A: Dear Student, To do this you need to first login to MySql client using command line then need to…

Q: What are the codes for this case? Emergency Department Patient Case Number: ED16-White, Salem…

A: In this question we have to define codes related to a patient case in the emergency department.…

Q: What exactly is the purpose of the info.bak document

A: ".bak" is a filename extension commonly used to signify a backup copy of a file. When a program is…

Q: Insert two maintenance in batch to the MAINTENANCES table. 523922 S O (D S Suspenen C (NG C WO Den O…

A: Since there are multiple questions, the first full question is answered for you. Please post the…

Q: DBA time is saved thanks to the DBMS's query optimisation procedures.

A: Dear learner, hope you are doing well, I will try my best to answer this question. Thank You!!

Q: 7. In the OrderItems table, display the maximum item_price with the alias shown. 11.99 Max Item…

A: Algorithm:Select the maximum value of the item_price column from the OrderItems table.Display the…

Q: Delete all the salesmen who make less than 200 in commission, including those who have not earned…

A: In SQL, to remove rows from a table, DELETE command is used. To determine which rows are deleted,…

Procedures in SQL

A pre-compiled stored procedure is a logical unit made up of one/more SQL statements (SQL stands for Structured Query Language). The database server saves it as an object. An SQL procedure is a collection of SQL statements and logic that is written and saved to accomplish a specified goal. An SQL procedure consists of a name, a parameter list, and a set of Transact-SQL statements. Stored procedures are stored as named objects in SQL Database Server.