Versions Compared

Old Version 8

changes.mady.by.user Tabassum Lodhi

Saved on

compared with

New Version Current

changes.mady.by.user Patrick Ackerman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

E.CRSE_GRADE_OFF = 'P' (eliminating students who have passed already)

Query Output Image:

...

Image Added

IDFirst NameMiddleLastCourse ListCount
16093648KamalMBashiru1119 CSTM  120 02 WU, 1112 CSTM  120 01 WU2


SQL Summery:

 
SELECT A.EMPLID, D.FIRST_NAME, D.MIDDLE_NAME, D.LAST_NAME, listagg( A.STRM || ' ' ||  A.SUBJECT || ' ' ||  A.CATALOG_NBR || ' ' ||  A.CLASS_SECTION || ' ' ||  A.CRSE_GRADE_OFF, ', ') within group (order by  A.STRM desc), COUNT( A.CRSE_ID)
  FROM PS_CLASS_TBL_SE_VW A, PS_STDNT_CAR_TERM B, PS_CU_BIO_VW D
  WHERE ( A.CRSE_ID IN ('090828','091787')
     AND A.STRM <= :1
     AND A.EMPLID = B.EMPLID
     AND A.ACAD_CAREER = B.ACAD_CAREER
     AND A.INSTITUTION = B.INSTITUTION
     AND B.STRM = :1
     AND EXISTS (SELECT C.EMPLID
  FROM PS_CLASS_TBL_SE_VW C
  WHERE ( C.STRM = :1
     AND C.CRSE_ID IN ('090828','091787')
     AND A.EMPLID = C.EMPLID
     AND A.CRSE_GRADE_OFF IN ('R','W','WU','WN') ))
     AND A.EMPLID = D.EMPLID
     AND A.INSTITUTION = :2
     AND NOT EXISTS (SELECT E.EMPLID
  FROM PS_CLASS_TBL_SE_VW E
  WHERE ( A.CRSE_ID IN ('090828','091787')
     AND A.EMPLID = E.EMPLID
     AND E.CRSE_GRADE_OFF = 'P'
     AND E.STRM = :1 )) )
  GROUP BY  A.EMPLID,  D.FIRST_NAME,  D.MIDDLE_NAME,  D.LAST_NAME
  ORDER BY 4, 2, 3

...