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

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

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!