Pregunta de entrevista de Accelerate People

Which of these four SQL codes is correct?