A) Write the following three queries in SQL and run it in MySQL.
Save each query and the corresponding results and submit the file.
a. List names, student numbers, and majors for students who have taken a course in the CS department.
b. List names, ID, and the total number of credit hours they have taken
c. List the courses which have two or more courses as their prerequisite with the department that is offering those courses.
If you wish you can submit one file by e-mail for all of the things you have done above. But, please make sure each part is clearly marked.
2. Question 8.14 - 20 points
3. Question 8.16 (Parts C and E only) – 20 points