Question: Please answer the following in MySql format QUERY 1: List the number of closed issues for each consultant. Include their consultant ID, first and last

Please answer the following in MySql format
1. 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 youre 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.

categoryID category 1 Hardware/Phone 2 Software/Voicemail 3 Internet/Web consultant ID firstName 4 Yoshio 3 Dean 10 Nicole 6 Prescott 11 Deborah 2 Claire 1 Tyrone 8 Nell 7 Hiram 5 Jameson 9 Deacon lastName email Long lylong@teleworks.com Conner dconner@teleworks.com Williams nwilliams@teleworks.com Martin pmartin@teleworks.com Zimmerman dzimmerman@teleworks.com Cameron cameron@teleworks.com Banks tbanks@teleworks.com Simon nsimon@teleworks.com Paul hpaul@teleworks.com Lyons jlyons@teleworks.com Solis dsolis@teleworks.com job Title businessPhone Software Engineer (643) 812-5568 Senior Consultant (490) 177-7685 Hardware Engineer (879) 640-0050 Hardware Engineer (691) 215-6715 Hardware Engineer (930) 773-1006 Senior Consultant (332) 237-8327 Senior Consultant (249)578-8770 Software Engineer (831) 625-9022 Junior Consultant (732) 297-4554 Junior Consultant (653) 746-9275 Senior Consultant (836)329-0317 mobilePhone (255) 547-3298 (419) 523-5750 (436) 678-2363 (546)511-3490 (560) 595-1719 (637) 299-3143 (640) 133-3203 (712) 608-9289 (745)720-5002 (835) 674-7730 (997) 266-1131 city Albuquerque Kirkland state NM WA postalCode 87110 98034 phone (206) 555-4116 (206) 555-4113 customer contactName address 1 Alexandra N. Elliott 105-134 Nec, Road 2 Amal K. Travis 112-1471 Dul Avenue Cherokee B. 3 Melendez 1901 Magna. Rd 4 Cyrus R. Brooks 1975 Uma Avenue 5 Dana X. Rosario 217-8515 Imperdiet Avenue 6 Deacon Q. Hart 2866 Dictum Av. 7 Dominic O. Bailey 336-7939 Accumsan Rd. 8 Gary H. Blanchard 4264 Dignissim St. 9 Gray V. Clements 493-8715 Condimentum St. 10 Hedda E. Lancaster 5052 Eu, Road 11 Jamalia A. Byrd 547 Ultrices St. 12 Kyla Y. Howe 6173 Hendrerit Rd. 13 Leandra Q. Foreman 665-9171 Erat. Ave 14 Maggie N. Davenport 709-6860 Quam Rd. 15 Maggy F. Miles 7135 Libero. Road 16 Megan J. Atkinson 957-8312 ld, St. 17 Miriam H. Roberts Ap #143-5881 Vulputate Rd. 18 Oleg J. Knowles Ap #202-8507 Quis Av. 19 Olympia Z. Hester Ap W205-6032 Montes, Rd. 20 Salvador E. Stafford Ap #244-6969 Sed Av. 21 Sean A. Reilly Ap #548-3814 Auctor Street 22 Stewart Z. Hyde Ap #579-598 Convallis Rd. 23 Sybil J. Rush Ap #830-2087 Tortor St. 24 Tashya S. Chan Ap #934-4273 Egestas. Ave 25 Taylor V. Dawson P.O. Box 216,7778 Dui St. 26 Vaughan B. Buckley P.O. Box 430, 2975 Gravida Street 27 Velma B. Mcmillan P.O. Box 622, 4358 Orci Rd. 28 Veronica R Page P.O. Box 720, 1178 Ullamcorper. St. 29 Wang F. Duke P.O. Box 896, 8407 Risus. St. 30 Willa Q. Harrington P.O. Box 971, 9801 Ut Rd. 31 Xenos G. Compton P.O. Box 992, 7355 Non St. Grand Rapids Mackinac Island Alexandria Grosse Pointe Birmingham Syosset East Michigan Benton Harbor Michigan Wherever Lander Seattle Traverse City Walla Wala San Francisco Anchorage Saint Louis Beverly Hills Washington Seattle Albany Beverly Hills Santa Fe Traverse City Ames Lansing Detroit Butte Shelby MI 49506 MI 49757 VA 22305 MI 48230 MI 48009 NY 11791 MI 48823 MI 49022 LA 44445 IN 77777 WY 82520 WA 98128 MI 49684 WA 99362 CA 94117 AK 99508 MO 63104 CA 90210 DC 20016 WA 98128 NY 12054 CA 90210 CA 92067 MI 49684 OH 98938 MI 48917 MI 48214 MT 59801 MI 49455 (616) 555-4123 (906) 555-4118 (703) 555-1843 (313) 555-1724 (248) 555-7560 (212) 528-5833 (517) 555-4119 (313) 555-0033 (444) 344-2553 (217) 334-4553 (206) 555-4117 (465) 555-3829 (231) 555-3729 (206) 555-4124 (206) 555-4121 (206) 555-4122 (314) 555-0594 (323) 555-8762 (202) 555-3145 (206) 555-4112 (517) 555-6097 (323) 555-8762 (619) 555-4578 (231) 555-4115 (224) 339-3232 (517) 555-4120 (313) 555-2841 (206) 555-4114 (231) 774-2000 statusID categoryID priorityID customerid consultantID 18 NNNN NNNNN GUNNNNNNNNNN 63 issueID issue Description 1 Wifi not connecting. 2 Cannot download apps. 3 Alarm clock does not work 4 Ringer does not work. 5 Camera is not working. 6 One key is broken. 7 Screen-brightness not adjusting. 8 Cannot delete apps. 9 Locked out of account. 10 Wifi not connecting 11 Wifi not connecting 12 Can not access menu on phone. 13 Wifi not connecting 14 Browser not loading. 15 Browser not loading, 16 Cannot delete apps. 17 Can not dial out of area. 18 Locked out of phone. 19 Alarm clock does not work 20 Browser not loading. 21 Cannot download apps. 22 Browser not loading. 23 Camera is not working. 24 Locked out of phone. 25 Cannot download apps. 26 Phone automatically turning off. 27 Can not access Web from phone. 28 Cannot access Web from phone. 29 Screen is frozen. 30 Can not access Web from phone. 31 Wifi not connecting. 32 Can not access menu on phone 33 Ringer does not work. 34 Can not access Web from phone. 35 Phone will not tum on. 36 Can not access menu on phone. 37 Cannot delete apps. 38 Screen is frozen. 39 Locked out of phone. 40 Lost password. 41 Lost password 42 Camera is not working. 43 Wifi not connecting. 44 No light 45 Screen is frozen. 46 Cannot delete apps. 47 Locked out of account. 48 Cannot download apps. 49 Locked out of account. 50 Screen is frozen. 51 Cannot download apps. 52 Cannot delete apps. 53 Screen-brightness not adjusting. 54 Screen-brightness not adjusting. 55 Phone will not tum on. 56 Cannot access voicemail. 57 Screen-brightness not adjusting. 58 Very bad 59 Can not access voicemail. date Opened 1/1/19 1/3/19 1/3/19 1/6/19 1/8/19 1/8/19 1/11/19 1/12/19 1/13/19 1/15/19 1/16/19 1/17/19 1/19/19 1/21/19 1/22/19 1/24/19 1/26/19 1/26/19 1/30/19 1/31/19 2/1/19 2/3/19 2/6/19 2/7/19 2/7/19 2/7/19 2/9/19 2/9/19 2/10/19 2/11/19 2/11/19 2/13/19 2/14/19 2/18/19 2/21/19 2/21/19 2/22/19 2/24/19 2/26/19 2/28/19 3/2/19 3/3/19 3/3/19 3/3/19 3/4/19 3/9/19 3/11/19 3/12/19 3/14/19 3/14/19 3/14/19 3/14/19 3/18/19 3/20/19 3/21/19 3/21/19 3/25/19 3/26/19 3/26/19 WWW UNWANNNNNNNN WUNNNNNNN UNNNNN INN oon on UAAAA C 2 en NGONNNN ANS 19 9 1 NO 2 2 statusID status 2 lopen 1 Closed priorityID (priority Level 5. Critical 4 High 3 Moderate 2 Standard 1 Low

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

the query logic itself. Scenario: The same manufacturing company from Assignment 1, Teleworks, has created and starting using the database for recording call center information. Now that they have...

how to do this on SQL 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...

Assignment \#1 - Single-row functions \& Subquery Due Date: Midnight of Feb 3 (Friday) Purpose: The purpose of this assignment is to help you: - Become familiar with the data source: City Jail...

MIS Management Information System Please answer by filling this table, Thanks! Query Question Answer 1 2 3 4 5 6 7 H film film_id title description release_year language_id original_language...

Task 2 [11 marks] using the Pulse Learning database For task 2, we have provided you with the creation script for the Pulse Learning database. You must run this script in MySQL Workbench and use this...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

Hi i need help with the following question database and SQL THE TABLE Quastions Issue Tracking Database keeps track of issues (problems) within a company reported by its users which handled by its IT...

I need help with this entire project. Please provide me with an organized solution. Thanks. INTRODUCTION Throughout your career in software development, you will develop and maintain new and existing...

I need help with this please. You must write a program containing two classes (i.e., Student and Roster). The program will maintain a current roster of students within a given course. Student data...

Pauline's Pastry Shop decides to remodel its offices this year. As part of the remodeling, Pauline's trades furniture with a cost of $12,000 that had been expensed in the year of purchase (Section...

In 1996, Financial World magazine estimated and ranked the most valuable brand names in the world. Number 11 in the ranking was Gillette with an estimated value of $10.3 billion. Financial World...

Which org is the most valuable esports org in the world? Question 2 5 options: 1 0 0 T Cloud 9 FaZe Clan TSM

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

The Nature of Nonverbal Communication

Functions of Nonverbal Communication

Nonverbal Communication Codes