#120 Extra classes assigned to students

[Michael Cortez]

These classes are classes that the student has never
enrolled in, and they are given Zero units in these
classes.

Found by:

select
PIDM, Class.ClassName, Count( ClassName ),
DiscoveryDate
from
roster,Class
where
Roster.Units = 0
and Roster.CampusCode <> '2NH'
and Roster.CampusCode NOT LIKE '1%'
and Roster.CRN = Class.CRN
and Roster.ExitDate > '12/20/01'

group by
PIDM, Class.ClassName, DiscoveryDate

having count( ClassName ) > 1