Exeter Finance interview question

Write SQL Statement psudeo code on the white board