Database (SQL commands)

12. Find the service ID and property ID for each service request whose estimated hours are greater than the number of estimated hours of at least one service request on which the category number is 5.

13.Find the service ID and property ID for each service request whose estimated hours are greater than the number of estimated hours on every service request on which the category number is 5.

SPENT_ NEXT HOURS SERVICE_DATE 1 11/01/2019 0 10/02/2019 1 11/09/2019 0 10/02/2019 SERVICE_REQUEST SERVICE PROPERTY CATEGORY_ OFFICE DESCRIPTION STATUS EST ID ID NUMBER NUM HOURS 11 2 2 The second Problem has 2 bedroom been confirmed. upstairs is not Central heating heating up at engineer has night. been scheduled. 4 1 A new strip light Scheduled 1 is needed for the kitchen. 3 6 5 1 The bathroom Service rep has 3 door does not confirmed issue. close properly. Scheduled to be refitted. 2 4 1 New outlet has been Scheduled 1 requested for the first upstairs bedroom. (There is currently no outlet). 5 8 3 2 New paint job Open 10 requested for the common area (lounge) 4 1 1 Shower is Problem 4 dripping confirmed. when not in use. Plumber has been scheduled 2. 2 1 Heating unit in Service rep 1 the entrance confirmed the smells like issue to be dust it's burning in the heating unit. To be cleaned. 9 1 2 Kitchen sink Problem 6 does not drain confirmed. properly. Plumber scheduled 9 12 6 2 New sofa requested. Open 2 FIGURE 1-8 Sample service request category 0 6 2. 10/07/2019 0 10/09/2019 2. 11/12/2019 0