Write SQL statement to list all course names taken by Student_Name = Smith. 2) Write SQL statement
Question:
Write SQL statement to list all course names taken by Student_Name = “Smith”.
2) Write SQL statement to list all faculty names who taught, ‘Baker’.
3) Write SQL statement to list all faculty members in the faculty table along the advisees’ names if faculty
member has any advisee(s). Otherwise, just list the faculty member’s information only.
4) Write SQL statement to display the advisor’s names of the students who have earned ‘A’ from ‘INFO
364’.
5) Write SQL statement to display the name of the instructor who teaches ‘JAVA’.
6) Write SQL statement to display the names of all students who have taken ‘Data Base’ and their grades.
7) Write SQL statement to display the names of all courses taken by each student.
8) Write SQL statement to display the names of all students who have learned from ‘William’.
9) Write SQL statement to list the total number of credits that each student has earned. Display a student’s
ID, Name and Total Number of Credits earned.
10) Write SQL statement to calculate each student’s GPA.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi