SQL-StayWell’s maintenance team is working on the staffing plan for the month of November 2019 including number of people required in the upcoming month. They need all the service requests with the category of Plumbing (category number 1) and Heating (category number 2), and the next service date within November 2019. You need to collect this information from service requests and send it to the team.To use BETWEEN condition with dates, do not forget to use the CAST function to convert the values to dates such as CAST('2019-01-01' AS DATE). SERVICE_ID PROPERTY_ID CATEGORY_NUMBER OFFICE_ID DESCRIPTIONSTATUSEST_HOURS SPENT_HOURS NEXT_SERVICE_DATEProblem has been confirmed.The second bedroom upstairs is notheating up at night.1112central heating engineer has been12019-11-01scheduled.2141A new strip light is needed for the kitchen. Scheduled12019-10-02The bathroom door does not closeService rep has confirmed issue.6.12019-11-09properly.Scheduled to be refitted.New outlet has been requested for thefirst upstairs bedroom. (There is currentlyno outlet).41Scheduled2019-10-02New paint job requested for the commonarea (lounge).532Оpen10NULLProblem confirmed. Plumber has411Shower is dripping when not in use.422019-10-07been scheduled.004.

The given requirement is to be solved in the form of SQL command where the only service requests are…

Answered: They need all the service requests with…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

SQL-

StayWell’s maintenance team is working on the staffing plan for the month of November 2019 including number of people required in the upcoming month. They need all the service requests with the category of Plumbing (category number 1) and Heating (category number 2), and the next service date within November 2019. You need to collect this information from service requests and send it to the team.

To use BETWEEN condition with dates, do not forget to use the CAST function to convert the values to dates such as CAST('2019-01-01' AS DATE).

SERVICE_ID PROPERTY_ID CATEGORY_NUMBER OFFICE_ID DESCRIPTION
STATUS
EST_HOURS SPENT_HOURS NEXT_SERVICE_DATE
Problem has been confirmed.
The second bedroom upstairs is not
heating up at night.
1
11
2
central heating engineer has been
1
2019-11-01
scheduled.
2
1
4
1
A new strip light is needed for the kitchen. Scheduled
1
2019-10-02
The bathroom door does not close
Service rep has confirmed issue.
6.
1
2019-11-09
properly.
Scheduled to be refitted.
New outlet has been requested for the
first upstairs bedroom. (There is currently
no outlet).
4
1
Scheduled
2019-10-02
New paint job requested for the common
area (lounge).
5
3
2
Оpen
10
NULL
Problem confirmed. Plumber has
4
1
1
Shower is dripping when not in use.
4
2
2019-10-07
been scheduled.
00
4.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions