Please create $.$csv files from Your submission document must include BOTH the SQL statement you wrote EXACTLY AS RUN and the results for each query execution.

Results can downloaded as a $.$CSV files from Oracle, opened in Excel, and copy$/$pasted to your Word document.

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

cost$,$ multiply the estimated hours by $35.$ Use the column name ESTIMATED$\_$COST for the

estimated labor cost.

ChatGPT

Here are the SQL statements I created based on the exercise prompts provided, I am unable to use the database nd just need a csv created from my sql entries:

List the owner number, last name, and first name of every property owner.

sql

SELECT OWNER$\_$NUMBER, LAST$\_$NAME, FIRST$\_$NAME FROM OWNERS;

List the complete PROPERTY table.

sql

SELECT $*$ FROM PROPERTY;

List the last name and first name of every owner who lives in Seattle.

sql

SELECT LAST$\_$NAME, FIRST$\_$NAME FROM OWNERS WHERE CITY $=$ 'Seattle';

List the last name and first name of every owner who does not live in Seattle.

sql

SELECT LAST$\_$NAME, FIRST$\_$NAME FROM OWNERS WHERE CITY $<>$ 'Seattle';

List the property ID and office number for every property whose square footage is equal to or less than $1,400$ square feet.

sql

SELECT PROPERTY$\_$ID$,$ OFFICE$\_$NUMBER FROM PROPERTY WHERE SQUARE$\_$FEET $<=1400$;

List the office number and address for every property with three bedrooms.

sql

SELECT OFFICE$\_$NUMBER, ADDRESS FROM PROPERTY WHERE BEDROOMS $=3$;

List the property ID for every property with two bedrooms that is managed by StayWell$-$Georgetown.

sql

SELECT PROPERTY$\_$ID FROM PROPERTY WHERE BEDROOMS $=2$ AND OFFICE $=$ 'StayWell$-$Georgetown';

List the property ID for every property with a monthly rent that is between $$1,350$ and $$1,750.$

sql

SELECT PROPERTY$\_$ID FROM PROPERTY WHERE MONTHLY$\_$RENT BETWEEN $1350$ AND $1750$;

List the property ID for every property managed by StayWell$-$Columbia City whose monthly rent is less than $$1,500.$

sql

SELECT PROPERTY$\_$ID FROM PROPERTY WHERE OFFICE $=$ 'StayWell$-$Columbia City' AND MONTHLY$\_$RENT $<1500$;

List the property ID$,$ category number, estimated hours, and estimated labor cost for every service request.

sql

SELECT PROPERTY$\_$ID$,$ CATEGORY$\_$NUMBER, ESTIMATED$\_$HOURS, $($ESTIMATED$\_$HOURS $*35)$ AS ESTIMATED$\_$COST FROM SERVICE$\_$REQUEST;