About Group by，Order by and limit

# synopsis
I use version 1.8
I want to use Group by and Order by Time to query data
# __Steps to reproduce:__
**Data**

**my sql**
`SELECT * FROM (
select last("3021") as "3021",last("3024") as "3024",last("3020") as "3020",last("3030") as "3030",last("3031") as "3031"
from cr_cs
where stationId = 126 and time >='2024-08-28T15:11:00+08:00' and time <'2024-08-28T15:34:05+08:00'
group by sn,time(60s) fill(none)
)
Order by time desc LIMIT 10 OFFSET 0`

**Result**

# Question:
1. sn=glcd05 and time = 2024-08-28T07:13:00Z,code=3030 Why is there no merging
2. the order is not desc

No source files or tests are identified. Start by reproducing the supplied SQL query against InfluxDB 1.8 with the shown data, then investigate why the grouped result does not merge the reported row and why the outer ORDER BY time DESC is not reflected in the result.

Written by the indexing model from the issue text.