Write SQL queries to answer the following questions: a. What are the courses included in the Section

Question:

Write SQL queries to answer the following questions:
a. What are the courses included in the Section table? List each course only once.
b. List all students in alphabetical order by StudentName.
c. List the students who are enrolled in each course in Semester I, 2015. Group the students by the sections in which they are enrolled.
d. List the courses available. Group them by course prefix. (ISM is the only prefix shown, but there are many others throughout the university.)
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Modern Database Management

ISBN: 978-0133544619

12th edition

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

Question Posted: