Question 2 VALL 1 Your data file should include data from a leasi throu ispartments (Computer Science, Matls, and BBA), at least 10 students and at least 20 courses. You may distribute students and courses evenly among the departments. You may also assign minor for some of the students. Be sure to assign multiple sections for some courses. Assuming that grades are available for the fall 2006 add enrolments of student in section and assign numeric grades Write SQL queries for the following: a) Retrieve names of students who are enrolled in Computer Science. (5 marks) b) Retrieve student numbers and first and last names of students with minor in BBA. (5 marks) c) Retrieve student numbers and first and last names of students who have cnly taken classes with an instructor named "Prof. Quarshie". (5 marks) Subali yn d) Retrieve department names and the number of students with that department major (sorted in decreasing order of the number of students). (5 marks) e) Retrieve a list of students and the courses they have registered, ordered by department and, within each departinent, ordered by alphabetically by last name. (5 marks) 25