Creating Queries using SQL SSB would like for you to generate several queries using the SQL "Query Design" feature in Access. The queries are designed to provide an overview of the data stored in the data mart andtechniques for answering specificquestions about customers, products, and employees. Query1 - Employee List Design a query to list all employees in the organization. The query should display the following information: employee ID, employee first name, employee last name, employeeaddress, employee salary, department name, and region name. Afterexecuting the query and verifying the query works correctly, save the query as "Queryl Query 2 Sales Representative List Design a query to list all sales people in the organization. The query should display the following information for the sales people in the organization(assuming everyone in the "sales" department is sales people): employee ID, sales rep first name, sales rep last name, sales rep address, sales rep salary sales rep department name, sales rep region name. Afterexecuting the query and verifying the query works correctly, save the query as "Query2". Query 3- Customer List Design a query to list all customers in alphabetical order by customer last name. The query should display the following information: customerID, customer first name, and customer last name. After executing the query and verifying the query works correctly, save the queryas "Query3" Query4 -Sales Orders in Ju Design a query to list all sales orders from 7/5/2012 to 7/14/2012 sorted in ascending order by purchase order date. The query should display the following information: PO date, orderID, product ID, product description, quantity sold, and unit price. Afterexecuting the query and verifying the query works correctly, save the query as "Query4 Query5 - Finding a Sales Order Construct a query to list all the products purchased by customerwhose last name start with A on July 13th, 2012. The query should displaythe following information: PO Date, orderID, customerID customerfirst name, customer last name, product ID, product description, quantity sold, and unit price Afterexecuting the query and verifying the queryworks correctly, save the query as "Query5