select distinct faculty,maslul_id,hug_noten,ord,course,nekudot,line,page,shana_le_toar,toar,missing,siduri,semester ,egedid,sidurieged from mainShnaton as c where maslul_id=9030 and faculty=02 and page=1 order by line,ord,siduri

total:1 pages: 1 page: 1

select COUNT( distinct course) as total , MAX(page) as pages from mainShnaton as c where maslul_id=9030 and faculty=02