FNZ interview question

asked for several sql queries how to improve the given tables