Meta interview question

Various complex SQL joins.