Intertek interview question

Oops concepts and SQL query, SQL query optimization