Skids interview question

A few coding in SQL