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



Leave a Reply 0

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