Applied Systems interview question

They asked questions to code in SQL.