Domanda di colloquio di Block

Standard SQL interview on how to group, aggregate and join