Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Task 1 : For every property, list the management office number, address, monthly rent, owner number, owner s first name, and owner s last name.
Task : For every property, list the management office number, address, monthly rent, owner number, owner s first name, and owner s last name. Task : For every completed or open service request, list the property ID description and status. Task : For every service request for janitorial work, list the property ID management office number, address, estimated hours, spent hours, owner number, and owner s last name. Task : List the first and last names of all owners who own a two bedroom property. Use the IN operator in your query. Task : Repeat Task but this time use the EXISTS operator in your query. Task : List the property IDs of any pair of properties that have the same number of bedrooms. For example, one pair would be property ID and property ID because they both have four bedrooms. The first property ID listed should be the major sort key and named as "PROPERTY ID MAJOR" and the second property ID should be the minor sort key and named as "PROPERTY ID MINOR". Include the number of bedrooms as BDRMS for reference. Task : List the square footage, owner number, owner last name, and owner first name for each property managed by the StayWell Columbia City office. Task : Repeat Task but this time include only those properties with three bedrooms. Task : List the office number, address, and monthly rent for properties whose owners live in Washington State or own two bedroom properties. Task : List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two bedroom property. Task : List the office number, address, and monthly rent for properties whose owners live in Washington State but do not own two bedroom properties. Task : 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 Task : Find the service ID and property ID for each service request whose estimated hours is greater than the number of estimated hours on all service requests on which the category number is Task : List the address, square footage, owner number, service ID number of estimated hours, and number of spent hours for each service request on which the category number is Task : Repeat Tasks but this time be sure each property is included regardless of whether it currently has any service requests for category From the textbook, A Guide to SQL sidenote the lists shown in this photo are in order, tried to make space for one photo, hope anyone can see it sorry
Task
: For every property, list the management office number, address, monthly rent, owner number, owner
s first name, and owner
s last name.
Task
: For every completed or open service request, list the property ID
description and status.
Task
: For every service request for janitorial work, list the property ID
management office number, address, estimated hours, spent hours, owner number, and owner
s last name.
Task
: List the first and last names of all owners who own a two
bedroom property. Use the IN operator in your query.
Task
: Repeat Task
but this time use the EXISTS operator in your query.
Task
: List the property IDs of any pair of properties that have the same number of bedrooms. For example, one pair would be property ID
and property ID
because they both have four bedrooms. The first property ID listed should be the major sort key and named as "PROPERTY
ID
MAJOR" and the second property ID should be the minor sort key and named as "PROPERTY
ID
MINOR". Include the number of bedrooms as
BDRMS
for reference.
Task
: List the square footage, owner number, owner last name, and owner first name for each property managed by the StayWell
Columbia City office.
Task
: Repeat Task
but this time include only those properties with three bedrooms.
Task
: List the office number, address, and monthly rent for properties whose owners live in Washington State or own two
bedroom properties.
Task
: List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two
bedroom property.
Task
: List the office number, address, and monthly rent for properties whose owners live in Washington State but do not own two
bedroom properties.
Task
: 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
Task
: Find the service ID and property ID for each service request whose estimated hours is greater than the number of estimated hours on all service requests on which the category number is
Task
: List the address, square footage, owner number, service ID
number of estimated hours, and number of spent hours for each service request on which the category number is
Task
: Repeat Tasks
but this time be sure each property is included regardless of whether it currently has any service requests for category
From the textbook, A Guide to SQL
sidenote
the lists shown in this photo are in order, tried to make space for one photo, hope anyone can see it
sorry
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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