Meta interview question

1. SQL Aggregation question on table 2. How would you check group health