Hi, Sample Data (CSV format) – student_id,student_name,class,school,subject,score 1,Alice,10A,School1,Math,85 2,Bob,10A,School1,Math,72 3,Charlie,10B,School1,Science,90 4,David,10A,School2,Math,65 5,Eva,10B,School2,Science,88 How to achieve this Query : You need to get 2 ranks for students 1. At class level 2. At school level. Kindly build this in single query.
... View more