MBA 614 SQL Query ExerciseUse the Courses_Students database for the following query tasks. Paste your SQLSELECT statementsunder their respective questions below. Submit only the SQL Select...

this is a SQl query question


MBA 614 SQL Query Exercise Use the Courses_Students database for the following query tasks. Paste your SQLS ELECT statements under their respective questions below. Submit only the SQL Select statements in this Word file, not any of the result sets. Also, no need to submit the database. last name, and zip code of all students in the database. Order the results by last 1. List the student i name in alphabetical order. 2. List the course_no, description, and costs of courses where the prerequisite is course number 20 or the cost is over $1500. Order the results by cost with the most expensive first. 3. Give me a lst of courses (by course_no) that are taught in room L509. List each course only once. 4. Give me a lst of sections (by section_id and section_no) and locations for course 125 that are not taught in 1509. 5. Retrieve a list of courses (by course number) where the cost is $1000 or more but less than $1500. 6. List the last name, frst name, and phone of al students in the database who phone number i blank. 7. Determine the date of the most recent enrollment. 8. List the course numbers (identified by course_no) and their total capacity across all sections. 9. Whatis the average capacity of all sections? 10. Give me the course number, description, and cost for all courses with a description starting with the. letter I" and whose costs are between $1000 and $1250 (inclusive). EE) 3 Petoningn - z ow cron - CT | ee] Twore | T cout Taco a 3 err oescarmOn T= cousero =! + Rep ¥ sicnowo cost Sccronmo neocon + cot te cooe rresecursTe Sram pare me ty ¥ Gade. coe occumseng Gens woawron frenspen cReareo_oaTE wsTRUCTOR 1D CREATED DATE comments “oom 1 amen woone. Guo MODIPED DATE cause or MODIED, DATE crear pate Grates owe Moores w Moonen, oat / T WeTAUCTOR, u 1 s1u00n 0. 5 Saimanon Sumanon pei vaste rer ZPCODE WAST Name ect scones 7] ncn oossss >» = — an 0] >» Guo. reo mors | come aren oe caren Moorea pice Guo | Voorn Moons gure Gruen owe Sooo. Moonen oure