FNZ interview question

Codility test with easy / lower intermediate questions, and an SQL task about joins and aggregate functions. I think they are pointless and don't show anything and is easy to cheat.