...
Records | Fields from the Record |
---|---|
CLASS_TBL_SE_VW | EMPLID,SUBJECT,CATALOG_NBR, DESCR,CLASS_SECTION, SESSION_CODE,CLASS_NBR, ACAD_GROUP, GRADE_DT |
CU_BIO_VW | FIRST_NAME, LAST_NAME, MIDDLE_NAME |
STDNT_CAR_TERM | SUPPORT CLASS_TBL_SE_VW ABOVE and counting STRM |
Expressions:
One 'Expressions' have been added to find 'Previous Attempts (R, W, WU)' to count the previous attempts of this particular class.
Prompt:
Institution, Term have been mandatory for an user to input to extract data
Criteria:
A.CRSE_ID - Course ID = '090828' (This is specifically looking for the course 'CSTM 120' attribute ), '091787' (only if FSPM exist)
Sub query: EXIST
AC.CRSE_GRADE_OFF - Official Grade in list ('R','W','WU') (the result is filtering only 'R','W','WU' grades)
Sub query: NOT EXIST
E.CRSE_GRADE_OFF = 'P' (eliminating students who have passed already)
Query Output Image:
SQL Summery:
...