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.

 

Student Table Student ID 1111 2222 3333 4444 Faculty Table Faculty_ID 1001 1010 1020 Registration Table Course ID INFO 364 INFO 364 INFO 345 INFO 345 Course Table Course_ID INFO 364 INFO 345 Student Name Williams Baker Smith Jones Faculty Name Johnson George William Student ID 1111 2222 2222 3333 Course Name Data Base JAVA Rank Advisor ID 1001 1010 1001 1010 Associate Full Associate Grade 4 2 3 4 Num_Credits 3 2 City Fair Oaks Columbia Spring Richmond State VA MD VA VA Instructor_ID 1001 1010 Postal Code 22601 20094 20234 23284 Student Table Student ID 1111 2222 3333 4444 Faculty Table Faculty_ID 1001 1010 1020 Registration Table Course ID INFO 364 INFO 364 INFO 345 INFO 345 Course Table Course_ID INFO 364 INFO 345 Student Name Williams Baker Smith Jones Faculty Name Johnson George William Student ID 1111 2222 2222 3333 Course Name Data Base JAVA Rank Advisor ID 1001 1010 1001 1010 Associate Full Associate Grade 4 2 3 4 Num_Credits 3 2 City Fair Oaks Columbia Spring Richmond State VA MD VA VA Instructor_ID 1001 1010 Postal Code 22601 20094 20234 23284