3. Given a table structure as follows. Studentss Student ID StudFirstName StudLa

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 (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

Explanation / Answer

Answer:

select student_id , avg(gpa) "GPA" from students gourp by student_id;

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.