Write SQL statements for the following queries. (number 1)

link to database image: http://faculty.eng.fau.edu/yangk/COP%203540,%20Spring%202018/homework/HW02.pdf

employee fname CHARACTER VARYINC15 minit CHARACTER VARYIN CT same CHARACTER VARVINGC) essmCHARACTERC bdate DATE address CHARACTER VARVING000) sex CHARACTERO salary NUMERIC super san CHARACTER) dependent works on CHARACTER dependerr name CHARACTER VARYINGK 16) sn CHARACTER) CHARACTERI DATE CHARACTER VARYING pno NUIERIC NUMERIC dept locations NUMERIC department NUMERIC project NUMERIC phame CHARACTER VARYINGGS pno plocation CHARACTER VARYING15) mgnsmCHARACTER) m prnstartod ate DATE NUMERI NUVERC Write SQL statements for the following queries. 1) Retrieve the first names of employees whose salary is between 70,000 and 80,000. 2) Retrieve the names of departments which is located in 'Miami'. 3) Retrieve the first names of employees who worked on the 'Middleware' project. 4) Retrieve the first names of employees whose manager is Jared James'. 5) Retrieve the first names of employees who worked on the 'ProductY" project and the ProductX' project