Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer in a MySql Format QUERY 3: Teleworks wants to find which customers have issues of which the priority level is critical and contact
Please answer in a MySql Format
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.
categoryID category 1 Hardware/Phone 2 Software/Voicemail 3 Internet/Web consultant ID firstName last Name email 4 Yoshio Long lylong teleworks.com 3 Dean Conner dconnerteleworks.com 10 Nicole Williams williams@teleworks.com 6 Prescott Martin pmartin@teleworks.com 11 Deborah Zimmerman dzimmermanteleworks.com 2 Claire Cameron Cameron teleworks.com 1 Tyrone Banks tbanksteleworks.com 8 Nell Simon nsimon@teleworks.com 7 Hiram Paul hpaul@teleworks.com 5 Jameson Lyons jlyons@teleworks.com 9 Deacon Solis dsolisteleworks.com jobTitle 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 postalCode NM 87110 WA 98034 p hone (206) 555-4116 (206) 555-4113 M customer contactName address 1 Alexandra N Elliott 105-134 Nec Road 2 Amalk 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 Bund 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 #205-6032 Montes, Rd. 20 Salvador E StaffordAp #244-6969 Sed Av 21 Sean A Rally Ap #548 3814 Auctor Street 22 Stewart Z. Hyde Ap #579-598 Convallis Rd. 23 Sybil J. Rush Ap #830-2087 Tortor SL 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 Wila Q. Harrington P.O.Box 971, 9801 Ut Rd. 31 Xenos G. Compton P.O. Box 992,7355 Non SL 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 Sheby M 49506 M 49757 VA 22305 48230 48009 NY 11791 48823 49022 44445 IN 77777 WY 82520 WA 98128 49684 WA 99362 CA 94117 AK 99508 MO 63104 CA 90210 DC 20016 WA 98128 NY 12054 CA 90210 CA 92067 M 49684 OH 98938 48917 48214 MT 59801 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-3629 (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 status ID categoryID priorityIDcustomerid consultantin NNNNNNNN CON NANNA 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 Scroon-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 aroa. 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 Win 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 GAON NN NN OOOO statusID status 2 lopen 1 Closed priority ID priority Level 5. Critical 4 High 3 Moderate 2 Standard categoryID category 1 Hardware/Phone 2 Software/Voicemail 3 Internet/Web consultant ID firstName last Name email 4 Yoshio Long lylong teleworks.com 3 Dean Conner dconnerteleworks.com 10 Nicole Williams williams@teleworks.com 6 Prescott Martin pmartin@teleworks.com 11 Deborah Zimmerman dzimmermanteleworks.com 2 Claire Cameron Cameron teleworks.com 1 Tyrone Banks tbanksteleworks.com 8 Nell Simon nsimon@teleworks.com 7 Hiram Paul hpaul@teleworks.com 5 Jameson Lyons jlyons@teleworks.com 9 Deacon Solis dsolisteleworks.com jobTitle 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 postalCode NM 87110 WA 98034 p hone (206) 555-4116 (206) 555-4113 M customer contactName address 1 Alexandra N Elliott 105-134 Nec Road 2 Amalk 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 Bund 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 #205-6032 Montes, Rd. 20 Salvador E StaffordAp #244-6969 Sed Av 21 Sean A Rally Ap #548 3814 Auctor Street 22 Stewart Z. Hyde Ap #579-598 Convallis Rd. 23 Sybil J. Rush Ap #830-2087 Tortor SL 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 Wila Q. Harrington P.O.Box 971, 9801 Ut Rd. 31 Xenos G. Compton P.O. Box 992,7355 Non SL 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 Sheby M 49506 M 49757 VA 22305 48230 48009 NY 11791 48823 49022 44445 IN 77777 WY 82520 WA 98128 49684 WA 99362 CA 94117 AK 99508 MO 63104 CA 90210 DC 20016 WA 98128 NY 12054 CA 90210 CA 92067 M 49684 OH 98938 48917 48214 MT 59801 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-3629 (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 status ID categoryID priorityIDcustomerid consultantin NNNNNNNN CON NANNA 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 Scroon-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 aroa. 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 Win 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 GAON NN NN OOOO statusID status 2 lopen 1 Closed priority ID priority Level 5. Critical 4 High 3 Moderate 2 Standard
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started