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:
1- Students Table:
Students (student_id (PK), student_name, age, grade)
2- Courses Table:
Courses (course_id (PK), course_name, instructor)
3- Enrollments Table:
Enrollments (enrollment_id (PK), student_id (FK), course_id (FK), enrollment_date)
What is the output of the following SQL statements:
Question 3
Not yet
answered
Marked out of
Flag question
SELECT AVG(grade) FROM Students GROUP BY age HAVING COUNT(*)>1;
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
 Consider three tables in a relational database: 1- Students Table: Students

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!