Why does AI seem to make things more complex than necessary?

Recently, I've been using a free, AI-powered querying tool to explore GitHub data and gain insights. I can ask it any questions about GitHub, and AI will generate SQL based on that and tell me the answer. In most cases, it will accurately answer my questions. For example, the most popular front-end projects in the last decade on GitHub.
However, it also often makes mistakes. Sometimes, I only ask about A, but it thinks I‘m asking about A, B, C, and D. This leads to incorrect SQL generated by AI. For example, when I asked about the most interesting metrics store projects, it thought I asked about the most popular, active, similar, fastest growing, and most contributors metrics store projects in GitHub. This resulted in invalid SQL generation.
The question link is here, if you're interested: https://ossinsight.io/explore/?id=3e634886-471c-4191-a65c-ae7fbcb5ffb1
Why does AI seem to make things more complex than necessary?