Check the example queries, one of them had aggregation and simple column selection in the same query with an "order by" clause at the end. I can't tell from th

Check the example queries, one of them had aggregation and simple column selection in the same query with an "order by" clause at the end. I can't tell from the output whether there is an implicit "group by" going on over the non-aggregated columns, but eg. this query produced some results without any errors: select windDir, avg(windSpeed) from weather