Question: 3. Given a table structure as follows. Studentss Student ID StudFirstName StudLastName PK Course ID CourseName PK IRI Student ID CPKFK Course ID CPKFR Year

3. Given a table structure as follows. Studentss Student ID StudFirstName StudLastName PK Course ID CourseName PK IRI Student ID CPKFK Course ID CPKFR Year (a) (15 points) Please show the SQL statement that find all courses taken by the student that has student ID-1 and the grades he she receives. The result set should look like: Student ID StudFirstName StudlastName Studlevel Student tD course JD Semester Year Grade Bob Bob Bob Bob Bob Freshman HandersonFreshman Handerson Freshman Handerson Freshman Handerson Freshman Sorina 2015 4 2016 3 Sorina 2016 2 2016 3 Sonina 2014 3 (b) (15 points) Please show the SQL statement that find the GPA for every student. student_id GPA 3.0000 2.7500 3.0000 4.0000 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
