Accelerate People interview question

Which of these four SQL codes is correct?