Select the SQL statement that corresponds to the record definition.

View the Exhibit.

Select the SQL statement that corresponds to the record definition.

View the Exhibit.

Select the SQL statement that corresponds to the record definition.

A.
SELECT
A.COURSE,A.SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,C.DESCR,A.ENROLL_DT
,A.ENROLL_STATUSFROM PS_PSU_STU_ENROLL A, PS_PSU_STUDENT_TBL B,
PS_PSU_CUST_TBL CWHERE A.STUDENT_ID = B.STUDENT_IDAND B.CUSTOMER_ID=
C.CUSTOMER_ID

B.
SELECT
A.COURSE,A.STUDENT_ID,A.SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,C.DESC
R,A.ENROLL_DT,A.ENROLL_STATUSFROM PS_PSU_STU_ENROLL A,
PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL BWHERE A.STUDENT_ID =
B.STUDENT_IDAND B.CUSTOMER_ID = B.CUSTOMER_ID

C.
SELECT
A.COURSE,A.STUDENT_ID,A.SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,C.DESC
R,A.ENROLL_DT,A.ENROLL_STATUSFROM PS_PSU_STU_ENROLL A,
PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL CWHERE A.STUDENT_ID =
B.STUDENT_IDAND B.CUSTOMER_ID = C.CUSTOMER_ID

D.
SELECT A.COURSE D.SELECT
A.COURSE,A.STUDENT_ID,A.SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,C.DESC
R,A.ENROLL_STATUS,A.ENROLL_DATEFROM PS_PSU_STU_ENROLL A,
PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL CWHERE A.STUDENT_ID =
B.STUDENT_IDAND B.CUSTOMER_ID = C.CUSTOMER_ID

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *