ORDER BY min(x) results in error Plan("No field named 'foo.x'. Valid fields are 'MIN(foo.x)'.")

[alamb]

Describe the bug
You can not refer to an aggregate directly in the ORDER BY clause

To Reproduce

echo "1" > /tmp/foo.csv
cargo run datafusion-cli

DataFusion CLI v5.1.0

❯ create external table foo(x int) stored as CSV location '/tmp/foo.csv';
0 rows in set. Query took 0.033 seconds.

❯ select min(x) from foo order by min(x);
Plan("No field named 'foo.x'. Valid fields are 'MIN(foo.x)'.")

Expected behavior
The query should produce a single column, with a single row 1

Note there are several workarounds to express this query that do work:

Refer to the item by index:

❯ select min(x) from foo order by 1;
+------------+
| MIN(foo.x) |
+------------+
| 1          |
+------------+
1 row in set. Query took 0.045 seconds.

Given the query an alias:

❯ select min(x) as min_x from foo order by min_x;
+-------+
| min_x |
+-------+
| 1     |
+-------+
1 row in set. Query took 0.010 seconds.

Additional context
Add any other context about the problem here.

[houqp]

I think there is a typo in your reproduction example? It should be the following right?

❯ select min(x) from foo order by min(x);
Plan("No field named 'foo.x'. Valid fields are 'MIN(foo.x)'.")

[alamb]

Yes sorry @houqp -- I have fixed that in the description