SQL query question..

[GetFahad]

Fail Mrs Sheri Grigg
Fail DR. GEORGE WILSON
Fail JILL DOAKE
Fail MARTIN HUGHES
Fail Dave Bird
Fail Mrs Sheri Grigg
Fail DR. GEORGE WILSON
Fail JILL DOAKE
Fail MARTIN HUGHES
Fail Dave Bird

cnt
==========
10


Pass Mrs Sheri Grigg
Pass DR. GEORGE WILSON
Pass JILL DOAKE
Pass MARTIN HUGHES
Pass Dave Bird
Pass Mrs Sheri Grigg
Pass DR. GEORGE WILSON
Pass JILL DOAKE
Pass MARTIN HUGHES
Pass Dave Bird
Pass Mrs Sheri Grigg
Pass DR. GEORGE WILSON
Pass JILL DOAKE
Pass MARTIN HUGHES
Pass Dave Bird
Pass Mrs Sheri Grigg
Pass DR. GEORGE WILSON
Pass JILL DOAKE
Pass MARTIN HUGHES
Pass Dave Bird
Pass Mrs Sheri Grigg
Pass DR. GEORGE WILSON
Pass JILL DOAKE
Pass MARTIN HUGHES


cnt
==========
20



from the information above, How would I show Seperatly the number of passes and the numbers of fails Each Person Has. (if possible, furthermore display the tutor with the highest number of fails)


The code below is what I 've gotten to so far and cant seem to figure out how I would do the above.
Code:

Select Mark, TutorsName
from PersonalTutor_0268381, Attend_0268381, Student_0268381
where Student_0268381.SID = Attend_0268381.SID
order by Mark
compute count (Mark) by Mark


Hope one can help me on this:)