Daffodil Software interview question

Mainly asked SQL and optimization in SQL.