LTM Limited interview question

Oops Concept, Basic Sql Questions