Aa boccdee Emphasis Heading 1 Normal Strong Subtitle Develop the following five queries. Be sure to keep a copy of the SQL logic and screenshots in the provided answer sheet on D2L. You can also save queries as .sal files to open later using the menu option File - > Save Script As. i) QUERY 1: List the number of closed issues for each consultant. Include their consultant ID, first and last names, email addresses, and the number of their closed issues. Do not show the status ID or status description (if you're using any one of them for the criteria purpose). Have the output column labeled Number of Closed Issues. Order by the consultants with the most closed. ii) QUERY 2: Which consultants serve customers in the state of Michigan? List the customers' (contact) names and the consultants' last names. Do not show the field of state. Do not show redundant records. Order by the consultants' last names. ill) QUERY 3: Teleworks wants to find which customers have issues of which the priority level is critical and contact them to ask for their opinions. List their contact names, phone numbers issue description, and corresponding consultants' last name. Do not show the field of Priority ID or PriorityLevel. iv) QUERY 4: Teleworks wants to figure out some metrics on their customers and what is outstanding. They would like to list all customers (contact name and phone number) and the total number of open critical priority issues and closed critical priority issues. The count for open issues will be on a separate line from the count of closed issues. Focus ' D E Aa boccdee Emphasis Heading 1 Normal Strong Subtitle Develop the following five queries. Be sure to keep a copy of the SQL logic and screenshots in the provided answer sheet on D2L. You can also save queries as .sal files to open later using the menu option File - > Save Script As. i) QUERY 1: List the number of closed issues for each consultant. Include their consultant ID, first and last names, email addresses, and the number of their closed issues. Do not show the status ID or status description (if you're using any one of them for the criteria purpose). Have the output column labeled Number of Closed Issues. Order by the consultants with the most closed. ii) QUERY 2: Which consultants serve customers in the state of Michigan? List the customers' (contact) names and the consultants' last names. Do not show the field of state. Do not show redundant records. Order by the consultants' last names. ill) QUERY 3: Teleworks wants to find which customers have issues of which the priority level is critical and contact them to ask for their opinions. List their contact names, phone numbers issue description, and corresponding consultants' last name. Do not show the field of Priority ID or PriorityLevel. iv) QUERY 4: Teleworks wants to figure out some metrics on their customers and what is outstanding. They would like to list all customers (contact name and phone number) and the total number of open critical priority issues and closed critical priority issues. The count for open issues will be on a separate line from the count of closed issues. Focus ' D E
