MBA 614 SQL Query Exercise Use the Courses Students database for the following query tasks. Paste your SQL SELECT 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.
1. List the student id, last name, and zip code of all students in the database. Order the results by last 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 list of courses (by course_no) that are taught in room L.. List each course only once.
4. Give me a list of sections (by section_id and section no) and locations for course 125 that are not taught in L509. 5. Retrieve a list of courses (by course number) where the cost is 51000 or more but less than $1500 6. List the last name, first name, and phone of all students in the database who phone number is 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. What is 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 ‘1. and whose costs are between $i000 and $1250 (inclusive).
r3 admo�.mR.
COURSE
DFTCAlRrDN CCESL COUT PUTI 0_81 CAL.70.0.E IAOgFlED DALE
INSTRUCTOR
.61MCTOR
SALVTAI1011
Host �uaa
SECTION

DPCOOE
O
ENROUMENT
= :PRUTLIC2 mu., 6, =oD.:(
GARDE

TIVIHNT 1 MOM-.
marl(
CRIAI t0,13.11