Question: Observe the ENROLLMENT AND COURSE database: ENROLLMENT EmpID EmpName CourseID 1 1 1 Joe AMG 2 2 2 Bob AMG 3 3 3 Lisa PMG

Observe the ENROLLMENT AND COURSE database:
ENROLLMENT
EmpID
EmpName
CourseID
111
Joe
AMG
222
Bob
AMG
333
Lisa
PMG
444
Sue
AMG
COURSE
CourseID
CourseName
AMG
Anger Management
PMG
Project Management
What will be the result of the following query?
SELECT count(*) FROM enrollment
GROUP BY courseid;
number 1
number 3
numbers 3 and 1
number 4
numbers 4,3, and 1

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!