Domanda di colloquio di Ergeon

How would you write a complex SQL query?