Question
Task 3: For every service request for janitorial work, list the property ID, management office number, address, estimated hours, spent hours, owner number, and owners
Task 3: For every service request for janitorial work, list the property ID, management office number, address, estimated hours, spent hours, owner number, and owners last name.
Task 4: List the first and last names of all owners who own a two-bedroom property. Use the IN operator in your query.
Task 6: List the property IDs of any pair of properties that have the same number of bedrooms. For example, one pair would be property ID 2 and property ID 6, because they both have four bedrooms. The first property ID listed should be the major sort key and the second property ID should be the minor sort key.
********SQL Queries***********
OFFICE table
OWNER table
PROPERTY table
RESIDENT table
SERVICE table
CATEGORY table
OWNER_NUM LAST_NAME FIRST_NAME ADDRESS AK102 Aksoy Ceyda 411 Griffin Rd. Bianchi Nicole 7990 Willow Dr. BU106 Burke Ernest 613 Old Pleasant St. Cole Meerab 9486 Circle Ave. Jones Ammarah 730 Military Ave. Kowalczyk Jakub 7431 S. Bishop St. Lopez Janine 9856 Pumpkin Hill Ln. Moore Elle-May 8006 W. Newport Ave. Patel Makesh 7337 Sheffield St. Redman Seth 7681 Fordham St. Sims Haydon 527 Primrose Rd. CITY STATE ZIP_CODE Seattle WA 98131 NewYorkTwinFallsNYID1000583303 OlympiaSeattleWAWA9850698126 SI105 - = Portland \begin{tabular}{cc} WA & 98226 \\ \hline WA & 98213 \\ \hline NV & 89508 \\ WA & 98119 \\ \hline WA & 98119 \\ \hline OR & 97203 \end{tabular} RESIDENT_ID FIRST_NAME SURNAME PROPERTY_ID 1 Albie ODRyan 1 2 Tariq Khan 1 3 4 5 6 7 8 9 Monique Salib 1 Beck 2 10 Amara Dejsuwan 4 CATEGORY_NUM CATEGORY_DESCRIPTION Plumbing 2 Heating 3 Painting 4 Electrical Systems 5 Carpentry 6 Furniture replacement
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started