Block Interview Question

Standard SQL interview on how to group, aggregate and join