Knack Systems interview question

sql queries and they are giving heavy coding questions.