Question: Write a query to display the patron ID, first and last name of all patrons whose first name starts with a letter M or last

Write a query to display the patron ID, first and last name of all patrons whose first name starts with a letter M or last name starts with a letter D, sort the results by first name and last name. New to SQL, Please Help

Here is the imported .csv folder uploaded on MySQL Bench

Write a query to display the patron ID, first and last name

Here is what is inside the .csv file

of all patrons whose first name starts with a letter M or

fact Tables author book checkout patron Columns PAT_ID PAT_FNAME PAT_LNAME PAT_TYPE Indexes Foreign Keys Triggers PAT_ID PAT_FNAN PAT_LNAN PAT_TYPE 1160 robert carter Faculty 1161 Kelsey Koch Faculty 1165 Cedric Baldwin Faculty 1166 Vera Alvarado Student 1167 Alan Martin FACULTY 1170 Cory Barry faculty 1171 Peggy Marsh STUDENT 1172 Tony Miles STUDENT 1174 Betsy Malone STUDENT 1180 Nadine Blair STUDENT 1181 Allen Horne Student 1182 Jamal Melendez STUDENT 1183 Helena Hughes Faculty 1184 Jimmie Love Student 1185 Sandra Yang student 1200 Lorenzo Torres Student 1201 Shelby Noble Student 1202 Holly Anthony Student 1203 Tyler Pope STUDENT 1204 Thomas Duran Student 1205 Claire Gomez student 1207 Iva Ramos Student 1208 Ollie Cantrell Student 1209 Rena Mathis Student 1210 Keith Cooley STUdent 1211 Jerald Gaines Student 1212 Iva McClain Student 1213 Desiree Rivas Student 1214 Marina King Student 1215 Maureen Downs Student 1218 Angel Terrell Student 1219 Desiree Harrington Student 1220 Carlton Morton Student 1221 Gloria Pitts Student 1222 Zach Kelly Student 1223 Jose Student 1224 Jewel England Student 1225 Wilfred Fuller Student 1226 Jeff Owens Student 1227 Alicia Dickson Student 1228 Homer Goodman Student 1229 Gerald Burke Student 1237 Brandi Larson Student 1238 Erika Bowen Student 1239 Elton Irwin Student 1240 Jan Joyce Student 1241 Irene West Student 1242 Mario King Student 1243 Roberto Kennedy Student 1244 Leon Richmond Student Hays

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!