This also matches my experience so far, but tbh top 10, group by, etc. queries are too easy. Llms produce terrible results on queries requiring multiple CTEs or complex tables. e.g. i still have not seen an llm able to calculate any stats on top of an intervals table.