Question: Consider three tables in a relational database: 1 - Students Table: Students ( student _ id ( PK ) , student _ name, age, grade
Consider three tables in a relational database:
Students Table:
Students studentid PK studentname, age, grade
Courses Table:
Courses courseid PK coursename, instructor
Enrollments Table:
Enrollments enrollmentid PK studentid FK courseid FK enrollmentdate
What is the output of the following SQL statements:
Question
Not yet
answered
Marked out of
Flag question
SELECT AVGgrade FROM Students GROUP BY age HAVING COUNT;
Select one:
a Average grade of students with the same age
b No output
c Average grade of all students
d Total number of students
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
