Pergunta de entrevista da empresa EPAM Systems

Write a SQL query on a condition based ?