Ugam interview question

SQL aggregations, Case (Use STAR to solve), behavioral