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 https://stackoverflow.com/questions/71251147/how-to-get-results-of-multiple-aggregations-in-a-single-druid-query