Question: Consider the following table EXAM _ RESULTS: table [ [ STUDENT _ ID , FIRST _ NAME,LAST _ NAME,EXAM _ ID , EXAM _

Consider the following table EXAM_RESULTS:
\table[[STUDENT_ID,FIRST_NAME,LAST_NAME,EXAM_ID,EXAM_SCORE],[10,LAURA,LYNCH,1,90],[10,LAURA,LYNCH,2,85],[11,GRACE,BROWN,1,78],[11,GRACE,BROWN,2,72],[12,JAY,JACKSON,1,95],[12,JAY,JACKSON,2,92],[13,WILLIAM,BISHOP,1,70],[13,WILLIAM,BISHOP,2,100],[14,CHARLES,PRADA,2,85]]
What is the result of the following SQL statement:
SELECT COUNT(DISTINCT STUDENT_
ID) FROM EXAM_RESULTS;
3
5
6
4
Consider the following table EXAM _ RESULTS: \

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 Programming Questions!