select count(*),subject_Description from proctor_details inner join subjects on subjects.subject_ID =prim_subject_ID
where detailapproved2=1 and prim_subject_ID<>0
group by subject_Description
;