Write SQL queries to answer the following questions: a. What are the courses included in the Section
Question:
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
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Question Posted: