Pergunta de entrevista da empresa Systems Limited

Write SQL query: Input Table id | source 1 | A 1 | C 2 | B 2 | C Condition : A > B > C Output id | source 1 | A 2 | B