ORDER BY with compound expr is not working

[akoshchiy]

Describe the bug

Query with compound sort expr (e.g. sum(a) + sum(b)) is failing.

To Reproduce

Run the script in datafusion-cli

CREATE TABLE t1(id INT, type VARCHAR, revenue INT);
INSERT INTO t1 VALUES (1, 'a', 199), (2, 'b', 238), (3, 'a', 301);

SELECT
        type,
        sum(revenue) + sum(revenue)
FROM t1
GROUP BY type
ORDER BY sum(revenue) + sum(revenue);

The output will be

type_coercion
caused by
Schema error: No field named t1.revenue. Valid fields are t1.type, "sum(t1.revenue) + sum(t1.revenue)".

Expected behavior

+------+----------------------------------+
| type | sum(t1.revenue)  + sum(t1.revenue) |
+------+----------------------------------+
| b    | 476                              |
| a    | 1000                            |
+------+----------------------------------+

Additional context

No response

[akoshchiy]

take