Write a query to display the first name, last name, and email address of employees hired from May 1, 2011, to December 31, 2012. Sort the output by last name and then by first name table 29Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name and then by first name, table 30I added the tables for the questionsThank you!! **Figure P7.30: Clerks and Employees in Department 300**This table provides detailed information about the clerks and employees working in Department 300. Below is the breakdown of each column and its contents:- **EMP_FNAME**: First name of the employee.- **EMP_LNAME**: Last name of the employee.- **EMP_PHONE**: Employee’s phone number.- **EMP_TITLE**: Job title of the employee.- **DEPT_NUM**: Department number, which is 300 for all employees listed here.**Table Details:**1. **LAVINA ACEVEDO** - Phone: 862-6787 - Title: ASSOCIATE2. **LAUREN AVERY** - Phone: 550-2270 - Title: SENIOR ASSOCIATE3. **ROSALBA BAKER** - Phone: 632-8197 - Title: ASSOCIATE4. **FERN CARPENTER** - Phone: 735-4820 - Title: PURCHASING SPECIALIST5. **LEEANN CLINTON** - Phone: 616-9615 - Title: CLERK I6. **TANIKA CRANE** - Phone: 449-6336 - Title: PURCHASING SPECIALIST7. **SAMMY DIGGS** - Phone: 525-2130 - Title: SENIOR ASSOCIATE8. **LANA DOWDY** - Phone: 471-8795 - Title: SENIOR ASSOCIATE9. **STEPHANIE DUNLAP** - Phone: 618-8203 - Title: BUYER - RAW MATERIALS10. **HAL FISHER** - Phone: 676-3662 - Title: SENIOR ASSOCIATE11. **LINDSAY GOOD** - Phone: 337-9570 - Title: CLERK I12. **LEEANN HORN** - Phone: 828-4361 - Title: SENIOR ASSOCIATEAll employees listed are part of Department 300, which includes a variety of job titles ranging from associates to purchasing specialists and clerks **Figure P7.29: Employees Hired within Dates**This table presents a list of employees, detailing their first names, last names, and corresponding email addresses. It is divided into three columns:1. **EMP_FNAME (First Name)**2. **EMP_LNAME (Last Name)**3. **EMP_EMAIL (Email Address)****Table Breakdown:**- **Doug Caudill**: Email - c.doug@lgcompany.com- **Olivia Deleon**: Email - o.deleon@lgcompany.com- **Gale Dewitt**: Email - g.dewitt1@lgcompany.com- **Francesco Elliot**: Email - f.elliott1@lgcompany.com- **Precious Farmer**: Email - p.farmer1@lgcompany.com- **Jannette Harrison**: Email - j.harrison@lgcompany.com- **Hal Hinkle**: Email - h.hinkle0@lgcompany.com- **Willard Long**: Email - w.long1@lgcompany.com- **Yong McDonald**: Email - y.mcdonald@lgcompany.com- **Denna McGraw**: Email - d.mcgraw1@lgcompany.com- **Rashida Neal**: Email - r.mcneal@lgcompany.com- **Gil Osborn**: Email - g.osborn@lgcompany.com- **Tonja Perkins**: Email - t.perkin0@lgcompany.com- **Stella Phelps**: Email - s.phelps1@lgcompany.com- **Mitchell Roland**: Email - m.roland0@lgcompany.com- **Darron Tilley**: Email - d.tilley@lgcompany.com- **Alejandra Whaley**: Email - w.alejandra0@lgcompany.com- **Alyson Willard**: Email - a.willar1@lgcompany.comThis table is formatted to provide a clear view of employee contact information, useful for understanding personnel hired within specific dates.

Here we have to write 2 queries whose details are as follows:Write a query to display the first name, last name, and email address of employees hired from May 1, 2011, to December 31, 2012. Sort the output by last name and then by first nameWrite a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name and then by first nameFor the first query we have to filter based on hire data and in case of second query we have to filter based on department number and titleThe sorting logic remained same for both the queriesSELECT EMP_FNAME, EMP_LNAME, EMP_EMAILFROM EMPLOYEESWHERE TO_CHAR(EMP_HIRE_DATE,'YYYYMMDD') BETWEEN '20110501' AND '20121231'ORDER BY EMP_LNAME, EMP_FNAME;SELECT EMP_FNAME, EMP_LNAME, EMP_PHONE, EMP_TITLE, DEPT_NUMFROM EMPLOYEESWHERE DEPT_NUM=300 OR EMP_TITLE='CLERK I'ORDER BY EMP_LNAME, EMP_FNAME;