SELECT ALL ' '||STUDENT.CLASS||' ('||STUDENT.SECTION||')' cls, 
COUNT(STUDENT.STUID) css, COUNT(ABSENT1.ASTUID) aas, STUDENT.STUDENTID
FROM STUDENT, ABSENT, ABSENT1
WHERE (STUDENT.STATUS = 'PRESENT'
 AND ABSENT1.ABDATE(+) = :P
 AND STUDENT.DOA(+)<:P)
 AND ((ABSENT1.ABDATE = ABSENT.ABDATE(+))
 AND (STUDENT.STUID(+)= ABSENT1.ASTUID))
GROUP BY ' '||STUDENT.CLASS||' ('||STUDENT.SECTION||')', 
' '||STUDENT.CLASS||' ('||STUDENT.SECTION||')', STUDENT.STUDENTID