For the following data, which has been loaded into the IS331FINAL Access Table, write a query that answers the following question What are the Student IDs, StudentName, Majorld, Majorname, Credits, Street Address, and Address zip code for any students that have an "S" anywhere in their first or last name? Show all columns in the STUDENT table and be sure to add the Majorname from the Major Table. Use a single letter alias name for the tables. Please note that the wild card character "%" in SQL Server is an "*" in Access STUDENT StudentID 151234 Major MGMT CS MATH IS CHE CS CHE CHE CHE StuName Jones, Ted Smith, Jane Kool, Bill Credits 41504 10927 28541 29624 29632 173437 179737 179741 an, Jackie Witt, Stu Kahn, Fran Johnson, Bob Johnson, Bob Johnson,Rob 7 101 68 93 75 65 119 118 107 Address St 555 Smith St 999 Post Ave 55 Sherwood Ave 1313 Mockingbird Ln 1776 Freedom Way 214 Valentine Court 207 Page Ave 141 Post Ave 141 Cabalbo Ave Address Zip 10001 07071 07032 86051 07453 07402 10001 07071 07422 MAJOR MajorlD MGMT CS MATH IS MajorName Management omputer Science Math Information Svstems Chemical Engineering HE