Nihilent interview question

how I would optimize a complex SQL query given a specific scenario, and which SQL concepts or techniques