Domanda di colloquio di Accelerate People

Which of these four SQL codes is correct?