Pergunta de entrevista da empresa FNZ

asked for several sql queries how to improve the given tables