List the office number, address, and monthly rent for properties whose owners live in Washington State or own two-bedroom properties.

 

Task 10: List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two-bedroom property.

 

 

Task 11: List the office number, address, and monthly rent for properties whose owners live in Washington State but do not own two-bedroom properties.

 

Task 12: Find the service ID and property ID for each service request whose estimated hours is greater than the number of estimated hours of any service request with category number 5.

      

Transcribed Image Text:

Lab 5-2: StayWell Student Accommodation Instructions Page 1 of 3 StayWell has decided that the best way to increase efficiency and move toward an e-commerce- based business model is to store all the data about the properties, owners, tenants and services in databases. This will mean that the information can be easily accessed. StayWell hopes that these databases can then be used in future projects such as mobile apps and online booking systems. ¥3 ا... | </> CENGAGE MINDTAP ? The data is split into several tables, shown below: The OFFICE table shows the office number, office name, address, area, city, state, and ZIP code. OFFICE NUM 1 2 OFFICE table OFFICE_NAME StayWell-Columbia City StayWell-Georgetown ADDRESS 1135 N. Wells Avenue 986 S. Madison Rd AREA Columbia City Georgetown CITY Seattle Seattle STATE WA WA = ZIP CODE 98118 98108 StayWell stores information about the owners of each property in the OWNER table. Each owner is identified by a unique owner number that consists of two uppercase letters followed by a < 1/3 > 1 2 -- query.sql + X Write your query below an Q Search this course SQL Viewe X X then click "Run Query" to execute it. To save multiple A-Z queries, click the "+" icon above. StayWell >_ Terminal x + Run a SQL query to generate results ? सई Lab 5-2: StayWell Student Accommodation Instructions Page 1 of 3 StayWell has decided that the best way to increase efficiency and move toward an e-commerce- based business model is to store all the data about the properties, owners, tenants and services in databases. This will mean that the information can be easily accessed. StayWell hopes that these databases can then be used in future projects such as mobile apps and online booking systems. ¥3 ا... | </> CENGAGE MINDTAP ? The data is split into several tables, shown below: The OFFICE table shows the office number, office name, address, area, city, state, and ZIP code. OFFICE NUM 1 2 OFFICE table OFFICE_NAME StayWell-Columbia City StayWell-Georgetown ADDRESS 1135 N. Wells Avenue 986 S. Madison Rd AREA Columbia City Georgetown CITY Seattle Seattle STATE WA WA = ZIP CODE 98118 98108 StayWell stores information about the owners of each property in the OWNER table. Each owner is identified by a unique owner number that consists of two uppercase letters followed by a < 1/3 > 1 2 -- query.sql + X Write your query below an Q Search this course SQL Viewe X X then click "Run Query" to execute it. To save multiple A-Z queries, click the "+" icon above. StayWell >_ Terminal x + Run a SQL query to generate results ? सई

Answer rating: 100% (QA)

Answer 9 To list the office number address and monthly rent for properties whose owners live in Washington State or own twobedroom properties you woul... View the full answer