Pregunta de entrevista de FNZ

asked for several sql queries how to improve the given tables