Hexaware Technologies interview question

They ask me to write SQL query they have provided condition.