How to get results of multiple aggregations in a single druid query?

Say I have the following table named t_student_details:

I want to get certain information about the students in a single query. This is what I would do in Postgres:

This is a companion discussion topic for the original entry at