Pregunta de entrevista de EPAM Systems

Write a SQL query on a condition based ?