its SQL:

Databasess and table :-

-- SQL SERVER STAYWELL SCHEMA

CREATE TABLE OWNER ( OWNER_NUM CHAR(5) PRIMARY KEY NOT NULL, LAST_NAME VARCHAR(20) NOT NULL, FIRST_NAME VARCHAR(20) NOT NULL, ADDRESS VARCHAR(100) NOT NULL, CITY VARCHAR(20) NOT NULL, STATE CHAR(2) NOT NULL, ZIP_CODE CHAR(5) NOT NULL );

-- Insert owners INSERT INTO OWNER VALUES('MO100','Moore','Elle-May','8006 W. Newport Ave.','Reno','NV','89508'); INSERT INTO OWNER VALUES('PA101','Patel','Makesh','7337 Sheffield St.','Seattle','WA','98119'); INSERT INTO OWNER VALUES('AK102','Aksoy','Ceyda','411 Griffin Rd.','Seattle','WA','98131'); INSERT INTO OWNER VALUES('CO103','Cole','Meerab','9486 Circle Ave.','Olympia','WA','98506'); INSERT INTO OWNER VALUES('KO104','Kowalczyk','Jakub','7431 S. Bishop St.','Bellingham','WA','98226'); INSERT INTO OWNER VALUES('SI105','Sims','Haydon','527 Primrose Rd.','Portland','OR','97203'); INSERT INTO OWNER VALUES('BU106','Burke','Ernest','613 Old Pleasant St.','Twin Falls','ID','83303'); INSERT INTO OWNER VALUES('RE107','Redman','Seth','7681 Fordham St.','Seattle','WA','98119'); INSERT INTO OWNER VALUES('LO108','Lopez','Janine','9856 Pumpkin Hill Ln.','Everett','WA','98213'); INSERT INTO OWNER VALUES('BI109','Bianchi','Nicole','7990 Willow Dr.','New York','NY','10005'); INSERT INTO OWNER VALUES('JO110','Jones','Ammarah','730 Military Ave.','Seattle','WA','98126');

-- Create PROPERTY table

CREATE TABLE PROPERTY ( PROPERTY_ID SMALLINT PRIMARY KEY NOT NULL, OFFICE_NUM TINYINT NOT NULL, ADDRESS VARCHAR(100) NOT NULL, SQR_FT SMALLINT NOT NULL, BDRMS TINYINT NOT NULL, FLOORS TINYINT NOT NULL, MONTHLY_RENT SMALLINT, OWNER_NUM CHAR(5) NOT NULL );

-- Insert properties INSERT INTO PROPERTY VALUES('1','1','30 West Thomas Rd.','1600','3','1',1400,'BU106'); INSERT INTO PROPERTY VALUES('2','1','782 Queen Ln.','2100','4','2',1900,'AK102'); INSERT INTO PROPERTY VALUES('3','1','9800 Sunbeam Ave.','1005','2','1',1200,'BI109'); INSERT INTO PROPERTY VALUES('4','1','105 North Illinois Rd.','1750','3','1',1650,'KO104'); INSERT INTO PROPERTY VALUES('5','1','887 Vine Rd.','1125','2','1',1160,'SI105'); INSERT INTO PROPERTY VALUES('6','1','8 Laurel Dr.','2125','4','2',2050,'MO100'); INSERT INTO PROPERTY VALUES('7','2','447 Goldfield St.','1675','3','2',1700,'CO103'); INSERT INTO PROPERTY VALUES('8','2','594 Leatherwood Dr.','2700','5','2',2750,'KO104'); INSERT INTO PROPERTY VALUES('9','2','504 Windsor Ave.','700','2','1',1050,'PA101'); INSERT INTO PROPERTY VALUES('10','2','891 Alton Dr.','1300','3','1',1600,'LO108'); INSERT INTO PROPERTY VALUES('11','2','9531 Sherwood Rd.','1075','2','1',1100,'JO110'); INSERT INTO PROPERTY VALUES('12','2','2 Bow Ridge Ave.','1400','3','2',1700,'RE107');

-- Create OFFICE table

CREATE TABLE OFFICE ( OFFICE_NUM TINYINT PRIMARY KEY NOT NULL, OFFICE_NAME VARCHAR(50) NOT NULL, ADDRESS VARCHAR(100) NOT NULL, AREA VARCHAR(50) NOT NULL, CITY VARCHAR(20) NOT NULL, STATE CHAR(2) NOT NULL, ZIP_CODE CHAR(5) NOT NULL );

-- Insert offices INSERT INTO OFFICE VALUES('1','StayWell-Colombia City','1135 N. Wells Avenue','Colombia City','Seattle','WA','98118'); INSERT INTO OFFICE VALUES('2','StayWell-Georgetown','986 S. Madison Rd','Georgetown','Seattle','WA','98108');

-- Create SERVICE_CATEGORY table

CREATE TABLE SERVICE_CATEGORY ( CATEGORY_NUM TINYINT PRIMARY KEY NOT NULL, CATEGORY_DESCRIPTION VARCHAR(100) NOT NULL );

-- Insert service categories INSERT INTO SERVICE_CATEGORY VALUES('1','Plumbing'); INSERT INTO SERVICE_CATEGORY VALUES('2','Heating'); INSERT INTO SERVICE_CATEGORY VALUES('3','Painting'); INSERT INTO SERVICE_CATEGORY VALUES('4','Electrical Systems'); INSERT INTO SERVICE_CATEGORY VALUES('5','Carpentry'); INSERT INTO SERVICE_CATEGORY VALUES('6','Furniture replacement');

-- Create SERVICE_REQUEST table

CREATE TABLE SERVICE_REQUEST ( SERVICE_ID SMALLINT PRIMARY KEY NOT NULL, PROPERTY_ID SMALLINT NOT NULL, CATEGORY_NUMBER TINYINT NOT NULL, OFFICE_ID TINYINT NOT NULL, DESCRIPTION VARCHAR(200) NOT NULL, STATUS VARCHAR(200) NOT NULL, EST_HOURS TINYINT NOT NULL, SPENT_HOURS TINYINT NOT NULL, NEXT_SERVICE_DATE DATE ); -- Insert service requests INSERT INTO SERVICE_REQUEST VALUES('1','11','2','2','The second bedroom upstairs is not heating up at night.','Problem has been confirmed. central heating engineer has been scheduled. ','2','1','2019-11-01'); INSERT INTO SERVICE_REQUEST VALUES('2','1','4','1','A new strip light is needed for the kitchen.','Scheduled','1','0','2019-10-2'); INSERT INTO SERVICE_REQUEST VALUES('3','6','5','1','The bathroom door does not close properly.','Service rep has confirmed issue. Scheduled to be refitted.','3','1','2019-11-09'); INSERT INTO SERVICE_REQUEST VALUES('4','2','4','1','New outlet has been requested for the first upstairs bedroom. (There is currently no outlet).','Scheduled','1','0','2019-10-02'); INSERT INTO SERVICE_REQUEST VALUES('5','8','3','2','New paint job requested for the common area (lounge). ','Open','10','0',NULL); INSERT INTO SERVICE_REQUEST VALUES('6','4','1 ','1','Shower is dripping when not in use.','Problem confirmed. Plumber has been scheduled.','4','2','2019-10-07'); INSERT INTO SERVICE_REQUEST VALUES('7','2','2','1','Heating unit in the entrance smells like its burning.','Service rep confirmed the issue to be dust in the heating unit. To be cleaned. ','1','0','2019-10-09'); INSERT INTO SERVICE_REQUEST VALUES('8','9','1','2','Kitchen sink does not drain properly. ','Problem confirmed. Plumber scheduled.','6','2','2019-11-12'); INSERT INTO SERVICE_REQUEST VALUES('9','12','6','2','New sofa requested.','Open','2','0',NULL);

-- Create RESIDENTS table

CREATE TABLE RESIDENTS ( RESIDENT_ID SMALLINT PRIMARY KEY NOT NULL, FIRST_NAME VARCHAR(20) NOT NULL, SURNAME VARCHAR(20) NOT NULL, PROPERTY_ID SMALLINT NOT NULL );

-- Insert residents INSERT INTO RESIDENTS VALUES('1','Albie ','ORyan','1'); INSERT INTO RESIDENTS VALUES('2','Tariq ','Khan','1'); INSERT INTO RESIDENTS VALUES('3','Ismail ','Salib','1'); INSERT INTO RESIDENTS VALUES('4','Callen ','Beck','2'); INSERT INTO RESIDENTS VALUES('5','Milosz ','Polansky','2'); INSERT INTO RESIDENTS VALUES('6','Ashanti ','Lucas','2'); INSERT INTO RESIDENTS VALUES('7','Randy ','Woodrue','2'); INSERT INTO RESIDENTS VALUES('8','Aislinn ','Lawrence','3'); INSERT INTO RESIDENTS VALUES('9','Monique ','French','3'); INSERT INTO RESIDENTS VALUES('10','Amara ','Dejsuwan','4'); INSERT INTO RESIDENTS VALUES('12','Rosalie ','Blackmore','4'); INSERT INTO RESIDENTS VALUES('13','Carina ','Britton','4'); INSERT INTO RESIDENTS VALUES('14','Valentino ','Ortega','5'); INSERT INTO RESIDENTS VALUES('15','Kaylem ','Kent','5'); INSERT INTO RESIDENTS VALUES('16','Alessia ','Wagner','6'); INSERT INTO RESIDENTS VALUES('17','Tyrone ','Galvan','6'); INSERT INTO RESIDENTS VALUES('18','Constance ','Fleming','6'); INSERT INTO RESIDENTS VALUES('19','Eamonn ','Bain','6'); INSERT INTO RESIDENTS VALUES('20','Misbah ','Yacob','7'); INSERT INTO RESIDENTS VALUES('21','Gianluca ','Esposito','7'); INSERT INTO RESIDENTS VALUES('22','Elinor ','Lake','7'); INSERT INTO RESIDENTS VALUES('23','Ray ','Rosas','8'); INSERT INTO RESIDENTS VALUES('24','Damon ','Caldwell','8'); INSERT INTO RESIDENTS VALUES('25','Dawood ','Busby','8'); INSERT INTO RESIDENTS VALUES('26','Dora ','Harris','8'); INSERT INTO RESIDENTS VALUES('27','Leroy ','Stokes','8'); INSERT INTO RESIDENTS VALUES('28','Tamia ','Hess','9'); INSERT INTO RESIDENTS VALUES('29','Amelia ','Sanders','9'); INSERT INTO RESIDENTS VALUES('30','Zarah ','Byers','10'); INSERT INTO RESIDENTS VALUES('31','Sara ','Farrow','10'); INSERT INTO RESIDENTS VALUES('32','Delilah ','Roy','10'); INSERT INTO RESIDENTS VALUES('33','Dougie ','McDaniel','11'); INSERT INTO RESIDENTS VALUES('34','Tahir ','Halabi','11'); INSERT INTO RESIDENTS VALUES('35','Mila ','Zhikin','12'); INSERT INTO RESIDENTS VALUES('36','Glenn ','Donovan','12'); INSERT INTO RESIDENTS VALUES('37','Zayn ','Fowler','12');

---------------------------------------------------------------------

7. List the square footage, owner number, owner last name, and owner first name for each property managed by the Columbia City office. 8. Repeat Exercise 7, but this time include only those properties with three bedrooms. 9. List the office number, address, and monthly rent for properties whose owners live in Washington state or own two-bedroom properties. 10. List the office number, address, and monthly rent for properties whose owners live in Washington state and own a two-bedroom property. 11. List the office number, address, and monthly rent for properties whose owners live in Washington state but do not own two-bedroom properties