$1.$ Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master.

$2.$ Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master and FirstName that begins with the letter J$.$

$3.$Write an SQL statement to list LastName, FirstName, and CellPhone of employees who have worked on a property in Seattle. Use a subquery.

$4.$Answer question G but use a join using JOIN ON syntax.

$/*****$ EMPLOYEE DATA $*********************************************************//*$ MySQL allows nulls in auto$\_$increment fields on insert to generate the next value $*/$ INSERT INTO EMPLOYEE VALUES$($null$,$ 'Smith', 'Sam', $\text{'}206-254-1234\text{'},$ 'Master'$)$; INSERT INTO EMPLOYEE VALUES$($null$,$ 'Evanston', 'John',$\text{'}206-254-2345\text{'},$ 'Senior'$)$; INSERT INTO EMPLOYEE VALUES$($null$,$ 'Murray', 'Dale', $\text{'}206-254-3456\text{'},$ 'Junior'$)$; INSERT INTO EMPLOYEE VALUES$($null$,$ 'Murphy', 'Jerry', $\text{'}585-545-8765\text{'},$ 'Master'$)$; INSERT INTO EMPLOYEE VALUES$($null$,$ 'Fontaine', 'Joan', $\text{'}206-254-4567\text{'},$ 'Senior'$)$; $/*****$ GG$\_$SERVICE DATA $**********************************************************//*$ MySQL allows nulls in auto$\_$increment fields on insert to generate the next value $*/$ INSERT INTO GG$\_$SERVICE VALUES$($null$,$ 'Mow Lawn', $25\mathrm{.}00)$; INSERT INTO GG$\_$SERVICE VALUES$($null$,$ 'Plant Annuals', $25\mathrm{.}00)$; INSERT INTO GG$\_$SERVICE VALUES$($null$,$ 'Weed Garden', $30\mathrm{.}00)$; INSERT INTO GG$\_$SERVICE VALUES$($null$,$ 'Trim Hedge', $45\mathrm{.}00)$; INSERT INTO GG$\_$SERVICE VALUES$($null$,$ 'Prune Small Tree', $60\mathrm{.}00)$; INSERT INTO GG$\_$SERVICE VALUES$($null$,$ 'Trim Medium Tree',$100\mathrm{.}00)$; INSERT INTO GG$\_$SERVICE VALUES$($null$,$ 'Trim Large Tree', $125\mathrm{.}00)$; $/*****$ PROPERTY$\_$SERVICE $**************************************************************//*$ MySQL allows nulls in auto$\_$increment fields on insert to generate the next value $*/$ INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,1,2,\text{'}2019-05-05\text{'},1,4\mathrm{.}50)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,3,2,\text{'}2019-05-08\text{'},3,4\mathrm{.}50)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,2,1,\text{'}2019-05-08\text{'},2,2\mathrm{.}75)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,6,1,\text{'}2019-05-10\text{'},5,2\mathrm{.}50)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,5,4,\text{'}2019-05-12\text{'},4,7\mathrm{.}50)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,3,1,\text{'}2019-05-15\text{'},4,2\mathrm{.}75)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,4,4,\text{'}2019-05-19\text{'},1,1\mathrm{.}00)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,7,1,\text{'}2019-05-21\text{'},2,2\mathrm{.}50)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,6,3,\text{'}2019-06-03\text{'},5,2\mathrm{.}50)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,5,7,\text{'}2019-06-08\text{'},4,10\mathrm{.}50)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,1,3,\text{'}2019-06-12\text{'},4,2\mathrm{.}75)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,4,5,\text{'}2019-06-15\text{'},1,5\mathrm{.}00)$; INSERT INTO PROPERTY$\_$SERVICE VALUES$($null$,7,3,\text{'}2019-06-19\text{'},2,4\mathrm{.}00)$;

CREATE TABLE OWNER$($ OwnerID Int NOT NULL AUTO$\_$INCREMENT, OwnerName Char$(50)$ NOT NULL, OwnerEmailAddress VarChar$(100)$ NULL, OwnerType Char$(12)$ NULL, CONSTRAINT OWNER$\_$PK PRIMARY KEY$($OwnerID$),$ CONSTRAINT OWNER$\_$TYPE$\_$CHECK CHECK $($OwnerType IN $(\text{'}$Individual$\text{'},$ 'Corporation'$)))$; CREATE TABLE OWNED$\_$PROPERTY$($ PropertyID Int NOT NULL AUTO$\_$INCREMENT, PropertyName VarChar$(50)$ NOT NULL, PropertyType VarChar$(50)$ NOT NULL, Street Char$(35)$ NOT NULL, City Char$(35)$ NOT NULL, State Char$(2)$ NOT NULL, ZIP Char$(10)$ NOT NULL, OwnerID Int NOT NULL, CONSTRAINT OWNED$\_$PROPERTY$\_$PK PRIMARY KEY$($PropertyID$),$ CONSTRAINT PROPERTY$\_$OWNER$\_$FK FOREIGN KEY $($OwnerID$)$ REFERENCES OWNER$($OwnerID$)$ ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT PROPERTY$\_$TYPE$\_$CHECK CHECK $($PropertyType IN $(\text{'}$Office$\text{'},$ 'Apartments', 'Private Residence'$)))$; CREATE TABLE EMPLOYEE$($ EmployeeID Int NOT NULL AUTO$\_$INCREMENT, LastName Char$(25)$ NOT NULL, FirstName Char$(25)$ NOT NULL, CellPhone Char$(12)$ NOT NULL, ExperienceLevel Char$(15)$ NOT NULL, CONSTRAINT EMPLOYEE$\_$PK PRIMARY KEY$($EmployeeID$),$ CONSTRAINT EXPERIENCE$\_$LEVEL$\_$CHECK CHECK $($ExperienceLevel IN $(\text{'}$Unknown$\text{'},$ 'Junior', 'Senior', 'Master' $,$ 'Guru'$)))$; CREATE TABLE GG$\_$SERVICE$($ ServiceID Int NOT NULL AUTO$\_$INCREMENT, ServiceDescription VarChar$(100)$ NOT NULL, CostPerHour Numeric $(6,2)$ NULL, CONSTRAINT GG$\_$SERVICE$\_$PK PRIMARY KEY$($ServiceID$))$; CREATE TABLE PROPERTY$\_$SERVICE$($ PropertyServiceID Int NOT NULL AUTO$\_$INCREMENT, PropertyID Int NOT NULL, ServiceID Int NOT NULL, ServiceDate Date NOT NULL, EmployeeID Int NOT NULL, HoursWorked Numeric $(4,2)$ NULL, CONSTRAINT PROP$\_$SERVICE$\_$PK PRIMARY KEY$($PropertyServiceID$),$ CONSTRAINT PROP$\_$SERVICE$\_$PROP$\_$FK FOREIGN KEY $($PropertyID$)$ REFERENCES OWNED$\_$PROPERTY$($PropertyID$)$ ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT PROP$\_$SERVICE$\_$SERVICE$\_$FK FOREIGN KEY $($ServiceID$)$ REFERENCES GG$\_$SERVICE$($ServiceID$)$ ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT PROP$\_$SERVICE$\_$EMP$\_$FK FOREIGN KEY $($EmployeeID$)$ REFERENCES EMPLOYEE$($EmployeeID$)$ ON DELETE NO ACTION ON UPDATE NO ACTION $)$; $/********************************************************************************/$

Please answer all $4$ questions on the top using WORD document