FNZ interview question

SQL select data, join tables, etc.