1. List the first name and surname of the residents who reside at 887 Vine Rd. 2....
Question:
1. List the first name and surname of the residents who reside at 887 Vine Rd.
2. List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two-bedroom property.
3. Find the service ID and property ID for each service request whose estimated hours is greater than the number of estimated hours on every service request on which the category number is 5.
4. List the square footage, owner number, owner last name, and owner first name for each three bedroom property managed by the Georgetown office.
5. 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.
6. List the first and last names of all owners who own a two-bedroom property. Use the EXISTS operator in your query.
7. For every service request for any type of work, list the property ID, management office number, address, estimated hours, spent hours, owner number, and owner's last name.
8. Add to the RESIDENTS table a new character column named OCCUPIED that is one character in length. (This column indicates whether the property is currently occupied.) Set the value for the OCCUPIED column on all rows to Y.
9. List the office number, address, and monthly rent for properties whose owners live in New York State but do not own three-bedroom properties.
10. For every property, list the management office number, address, monthly rent, owner number, owner's first name, and owner's last name.
1. List the first name and surname of the residents who reside at 887 Vine Rd.
2. List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two-bedroom property.
3. Find the service ID and property ID for each service request whose estimated hours is greater than the number of estimated hours on every service request on which the category number is 5.
4. List the square footage, owner number, owner last name, and owner first name for each three bedroom property managed by the Georgetown office.
5. 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.
6. List the first and last names of all owners who own a two-bedroom property. Use the EXISTS operator in your query.
7. For every service request for any type of work, list the property ID, management office number, address, estimated hours, spent hours, owner number, and owner's last name.
8. Add to the RESIDENTS table a new character column named OCCUPIED that is one character in length. (This column indicates whether the property is currently occupied.) Set the value for the OCCUPIED column on all rows to Y.
9. List the office number, address, and monthly rent for properties whose owners live in New York State but do not own three-bedroom properties.
10. For every property, list the management office number, address, monthly rent, owner number, owner's first name, and owner's last name.
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last