Question: Task 1 1 : List the owner number and last name for all owners who live in Nevada ( NV ) , Oregon ( OR
Task : List the owner number and last name for all owners who live in Nevada NV Oregon OR or Idaho ID
Task : List the office number, property ID square footage, and monthly rent for all properties. Sort the results by monthly rent within the square footage.
Task : How many threebedroom properties are managed by each office? Use OFFICENUM and COUNT as column headers.
Task : Calculate the total value of monthly rents for all properties, display this value in a column labeled TOTALVALUE.
Task : Write a query using a WHERE clause to find all service requests with the word heating anywhere in the description field.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
