PrepAway - Latest Free Exam Questions & Answers

Category: 000-302

Exam 000-302: DB2 9 Database and Application Fundamentals

What would the result be?

Given the following tables with the given data:
STUDENT
——————name id
—– —–Jim 1
Sarah 2
Frank 3
PROFESSOR
——————name course
—– —–Jenny PHY_102
Mark MAT_202
Angie DB_101
Jenny CSI_201
ENROLL
——————student_id course_id
—— —–

2 PHY_102
2 DB_101
3 PHY_102
1 CSI_201
3 MAT_202
After executing the query:
SELECT P.name, COUNT AS COUNT FROM STUDENT LEFT JOIN ENROLL
ON id=student_id, PROFESSOR AS P
GROUP BY P.name
What would the result be?


Page 4 of 19« First...23456...10...Last »