Use the SQL Workbench. Only answer the EVEN numbered questions.

StayWell Student Accommodation Use SQL and the StayWell Student Accommodation database (Figures 1-4 through 1-9 in Module 1) to complete the following exercises. If directed to do so by your instructor, use the information provided with the Module 3 Exercises to print your output or save it to a document. 1. List the owner number, last name, and first name of every property owner. 2. List the complete PROPERTY table (all rows and all columns). 3. List the last name and first name of every owner who lives in Seattle. 4. List the last name and first name of every owner who does not live in Seattle. 5. List the property ID and office number for every property whose square footage is equal to or less than 1,400 square feet. 6. List the office number and address for every property with three bedrooms. 7. List the property ID for every property with two bedrooms that is managed by StayWell-Georgetown. 8. List the property ID for every property with a monthly rent that is between $1,350 and $1,750. 9. List the property ID for every property managed by StayWell-Columbia City whose monthly rent is less than $1,500. 10. Labor is billed at the rate of $35 per hour. List the property ID, category number, estimated hours, and estimated labor cost for every service request. To obtain the estimated labor oost, multiply the estimated hours by 35 . Use the column name ESTIMATED_COST for the estimated labor cost. 11. List the owner number and last name for all owners who live in Nevada (NV), Oregon (OR), or Idaho (ID). 12. List the office number, property ID, square footage, and monthly rent for all properties. Sort the results by monthly rent within the square footage. 13. How many three-bedroom properties are managed by each office? 14. Calculate the total value of monthly rents for all properties. Introduction to KimTay Pet Supplies and StayWell Student Acoommodi FIGURE 1-5 Sample data for the owners of StayWell properties FIGUAE 1-6 Sample data for StayWell properties It might at first seem reasonable to include property IDs in the OWNER table, as it would require single rows to contain StayWell provides maintenance services across the properti this is shown in Figure 1-7. The SERVICE_CATEGORY table in these services. The CATEGORY_NUM provides a unique numbe CATEGORY_DESGRIPTION shows what the service is. FIGURE 1-7 Sample category data for StayWell maintenance serv with the mount of time and the date of the action to De taken, where applicable. The RESIDENTS database, as shown in Figure 1-9, includes details about the residents living in each property. The RESIDENT column includes the first name and last name for each of the residents, along with a resident ID. The PROPERTY_ID is the unique identifieation number of the property in which they are staying. Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases the PROPERT the reque ded, plus the licludec about the first name and last Y.ID is the unique currently done via emiar commere-based business model is to store all the mases. This will mean that the information can bh ens, tenants and services in that these databases can then be used in future projecof aocessed. Say mobile apps and online into several tables as described below. The data is split in shown in Figure 1-4 shows the office number, office locatis The OFFICE table shown in Fighes, FIGURE 14 Sample data for StayWell offices StaylWell is split into two offices to better manage the properties. This manaza includes communicating with owners about the status and upkeep of their properia They also facilitate the payment from the properties, meaning that the owners giti lar income without having to collect rent in arrears. Offices also advertise properie place students in appropriate properties, facilitating initial visits and taking deposis Lastly the office administers the maintenance of the properties, communicating " residents, owners, and maintenance services. This is discussed later