[Solved]1 Use Database Downloaded Develop Following Queries Save Query Query 1 Query 2 Etc Query 1 Q37206296
1) Use the database you downloaded to develop the following queries. Save each query as “query 1”, “query 2”, etc QUERY 1: List all issues that are open, Include Issue ID and Issue descriptions. i) (2 points) ii) QUERY 2: List each consultants who have open issue. Include their first and last names and their email addresses. (3 points) iii) QUERY 3: Which consultants serve customers in Washington State? List the customers’ (contact) names and the consultants’ last names. (4 points) iv QUERY 4: Teleworks wants to find which consultants are handling the critical issues, and contact them to ask for an update. List the priority level, each consultants ID and email address. (5 points) QUERY 5: Teleworks wants to find out all closed issues with high priority or any issues that are about hardware/phone. Please include Issue ID, Customer Contact Name and ConsultantID. (6 points) v) Status Priority StatusID Status PrioritylD PriorityLevel Issues Issue ID Issue Description Date Opened Status ID Category ID Priority ID Customer ID Consultant ID IssueCategory Category ID Category Consultants ConsultantID First Name Last Name E-mail Address ob Title Business Phone Mobile Phone Customers Customer ID Contact Name Address City State Postal Code Phone Show transcribed image text 1) Use the database you downloaded to develop the following queries. Save each query as “query 1”, “query 2”, etc QUERY 1: List all issues that are open, Include Issue ID and Issue descriptions. i) (2 points) ii) QUERY 2: List each consultants who have open issue. Include their first and last names and their email addresses. (3 points) iii) QUERY 3: Which consultants serve customers in Washington State? List the customers’ (contact) names and the consultants’ last names. (4 points) iv QUERY 4: Teleworks wants to find which consultants are handling the critical issues, and contact them to ask for an update. List the priority level, each consultants ID and email address. (5 points) QUERY 5: Teleworks wants to find out all closed issues with high priority or any issues that are about hardware/phone. Please include Issue ID, Customer Contact Name and ConsultantID. (6 points) v)
Status Priority StatusID Status PrioritylD PriorityLevel Issues Issue ID Issue Description Date Opened Status ID Category ID Priority ID Customer ID Consultant ID IssueCategory Category ID Category Consultants ConsultantID First Name Last Name E-mail Address ob Title Business Phone Mobile Phone Customers Customer ID Contact Name Address City State Postal Code Phone
Expert Answer
Answer to 1) Use the database you downloaded to develop the following queries. Save each query as “query 1”, “query 2”, etc QUERY … . . .
OR
