Pergunta de entrevista da empresa Barclays

how would you optimise your sql query? what tools would you use?