Hi everyone

I am new to programing and learning via the "trial by fire" method.

The program I am using is based on Pascal and SQL statements. The database responds to SQL statements okay. It is not a Microsoft Program.
Operating system is NT 4.0

<problem>
Need to find out the total number of each status type for this class.

<set-up>
Table Name: Registrations
Field Name: EnrolSTATUS
Field Name: Class_OID (the class number I am working on is 1300)

The status have 4 different types
0 = enrolled
1 = finished
2 = cancelled
3 = No Show

<Didn't Work Statement>

SELECT * FROM REGISTRATIONS WHERE REGISTRATIONS.CLASS_OID = 1300 AND
Count(*) REGISTRATIONS.EnrolSTATUS = 1


I am hoping this makes more sense to someone else.