Counting Subgroups with SQL Joins

Using a set of tables, craft SQL queries to calculate the count of specific subgroups by utilizing joins.

Answer Panel