For each question, submit your SQL code and a screenshot of the results. If the

For each question, submit your SQL code and a screenshot of the results. If the results are
too long, partial results are fine. Include relevant attributes for each result, to explain that
the result is correct. Do NOT include many unnecessary attributes. Do NOT use SELECT *.
1) List the articles (any type, not just articles) appearing in less than 2 coursepacks. List the article Number, Article Price, and the number of times they appear in a coursepack.
2) List the MBA students who are enrolled in any MSBA course. List the student’s name, gender, and GPA.
3) List courses starting in August (any day) with an average number of sections of 5 or more.
4) Find all case articles (format=”case”) required for DAT courses. Sort the results by the article title. List only the title, and article number.
5) List the students with a GPA less than 3.5 who are enrolled in 3 or fewer courses. List the
student’s name, major, and the number of enrolled courses. Order the results based on the
number of enrolled courses in decreasing order.
6) Find programs with more than 6 courses listed in the database. List the program name, total
number of sections, and earliest starting date of courses.
7) Find the average GPA of students that are required to take any courses in the BSBA program. List the course number, course name, and average GPA of enrolled students. List only the courses with an average GPA of more than 3.
8) For each student who is enrolled in more than 3 courses find the name, gender, and the number of enrolled courses. Order the result in increasing order of enrolled courses.
9) Find the pairs of articles (any type of article, means article, case, simulation,..) from the same
publishers with different formats. List the article number, Title, and publisher.
10) Find the courses enrolled by any student who has the letter “D” in their name. List the course name, section, and faculty name.
11) Find the courses taught by female faculties with more than 4 students enrolled. List the course number, faculty name, number of enrolled students, and program.
12) For the courses which have group assignment, list the course number, course name, title, article number, author, and assignment date. Only include coursepacks with assigned dates in September or October. Sort the results in ascending order of course name. Hint: You need to use Coursepacks.Group for the Group attribute.