Question: please answer the question in the first photo, which is related to the second photo!!!!!!! dlove Copy the SQL Command and paste it in the


please answer the question in the first photo, which is related to the second photo!!!!!!!
dlove Copy the SQL Command and paste it in the answer Find all the Patrons where the Patron type is Student. Keep in mind that we need all kinds of student patron even if they are spelled with all upper case or lower case. comand from SS EISELECT TOP (1980) [PAT_ID] IPAT FNAME] IPAT_LNAME] [PAT_TYPE] FROM [master][dbo][PATRON] 100 % EE Results PATID PAT_LNAME 1 1160 Messages PAT FNAME robert Kelsey Cedric carter 2. 1161 Koch 1165 1166 4 Vera 5 Baldwin Alvarado Martin Barry Marsh Miles 6 Alan Cory Peggy Tony Betsy Nadine 7 PAT_TYPE Faculty Faculty Faculty Student FACULTY faculty STUDENT STUDENT STUDENT STUDENT Student STUDENT Faculty Student 8 9 Malone 10 1167 1170 1171 1172 1174 1180 1181 1182 1183 1184 1185 1200 1201 Blair 12 13 14 Allen Jamal Helena Jimmie Sandra Lorenzo Shelby Horne Melendez Hughes Love Yang Torres Noble 15 16 Student Student 17
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
