Students SQL Query

These are the columns in the exam_report table
EXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCE
now i want to know how many student have passed at the end of the yr for each paper? and if they r failed i need to know there mark of the last appearance for each paper(ie)he might have appeared 5 times but still he may have failed and i want the mark of the 5 appearance

Questions by radha11

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions