Tables Jesmieskoconsultants Jesmieskocustomers jesmieskoissuecateg. jesmieskoissues jesmieskoissuestatus jesmieskopriority 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. categoryID [category 1Hardware/Phone 2 Software/Voicemail 3 Internet/Web Job Title 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 business Phone mobilePhone Software Engineer (643) 812-5568 (255)547-3298 Senior Consultant (490) 177-7685 (419) 523-5750 Hardware Engineer (879) 640-0050 (436) 678-2363 Hardware Engineer (691) 215-6715 (546)511-3490 Hardware Engineer (930) 773-1006 (560)595-1719 Senior Consultant (332) 237-8327 (637) 299-3143 Senior Consultant (249) 578-8770 (640) 133-3203 Software Engineer (831) 625-9022 (712) 608-9289 Junior Consultant (732) 297-4554 (745)720-5002 Junior Consultant (653) 746-9275 (835) 674-7730 Senior Consultant (836)329-0317 (997)266-1131 city Albuquerque Kirkland state NM WA postalCode 87110 98034 phone (206) 555-4116 (206) 555-4113 NY customer contactName address 1 Alexandra N. Elliott 105-134 Nec, Road 2 Amal K. Travis 112-1471 Dui. 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 7 135 Libero. Road 16 Megan J. Atkinson 957-8312 Id, 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. 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 Walla 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 11791 MI 48823 MI 49022 LA 44445 IN 77777 WY82520 WA 98128 MI 49684 WA 99362 94117 AK 99508 MO 63104 CA 90210 DC 20016 WA 98128 12054 CA 90210 92067 49684 OH 98938 MI 48917 MI 48214 MT 59801 MI 49455 CA (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 NY CA statusID categoryID priorityIDcustomerid consultantin 10 59 18 NASA 28 15 ----N-NNNNNNNNNN-NA-N IssuelD i ssue Description 1 Wifi not connecting. 2 Cannot download apps. 3 Alam 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 tuming 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 nian NNW WWWWWWNWENNENWNNNNNW WNW WNNNNNWNWWWNNNNNNN NONANNAN OON NA AANNNN WWUNUN 14 DA IELA statusID status 2lOpen 1 Closed priorityID priority Level 5. Critical 4 High 3 Moderate 2 Standard 1 Low Tables Jesmieskoconsultants Jesmieskocustomers jesmieskoissuecateg. jesmieskoissues jesmieskoissuestatus jesmieskopriority 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. categoryID [category 1Hardware/Phone 2 Software/Voicemail 3 Internet/Web Job Title 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 business Phone mobilePhone Software Engineer (643) 812-5568 (255)547-3298 Senior Consultant (490) 177-7685 (419) 523-5750 Hardware Engineer (879) 640-0050 (436) 678-2363 Hardware Engineer (691) 215-6715 (546)511-3490 Hardware Engineer (930) 773-1006 (560)595-1719 Senior Consultant (332) 237-8327 (637) 299-3143 Senior Consultant (249) 578-8770 (640) 133-3203 Software Engineer (831) 625-9022 (712) 608-9289 Junior Consultant (732) 297-4554 (745)720-5002 Junior Consultant (653) 746-9275 (835) 674-7730 Senior Consultant (836)329-0317 (997)266-1131 city Albuquerque Kirkland state NM WA postalCode 87110 98034 phone (206) 555-4116 (206) 555-4113 NY customer contactName address 1 Alexandra N. Elliott 105-134 Nec, Road 2 Amal K. Travis 112-1471 Dui. 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 7 135 Libero. Road 16 Megan J. Atkinson 957-8312 Id, 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. 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 Walla 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 11791 MI 48823 MI 49022 LA 44445 IN 77777 WY82520 WA 98128 MI 49684 WA 99362 94117 AK 99508 MO 63104 CA 90210 DC 20016 WA 98128 12054 CA 90210 92067 49684 OH 98938 MI 48917 MI 48214 MT 59801 MI 49455 CA (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 NY CA statusID categoryID priorityIDcustomerid consultantin 10 59 18 NASA 28 15 ----N-NNNNNNNNNN-NA-N IssuelD i ssue Description 1 Wifi not connecting. 2 Cannot download apps. 3 Alam 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 tuming 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 nian NNW WWWWWWNWENNENWNNNNNW WNW WNNNNNWNWWWNNNNNNN NONANNAN OON NA AANNNN WWUNUN 14 DA IELA statusID status 2lOpen 1 Closed priorityID priority Level 5. Critical 4 High 3 Moderate 2 Standard 1 Low