Block interview question

Standard SQL interview on how to group, aggregate and join