chatdata 经常返回 ERROR!Can not find sql in response #2507
Unanswered
Hermione-he
asked this question in
Q&A
Replies: 1 comment
-
Please try v0.7.0 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
chatdata 经常返回 ERROR!Can not find sql in response,不知道是不是哪里设置的问题,sql语句贴到数据库客户端去运行,一切正常。

Q:查询每个用户的总订单数量
A:{ "thoughts": "用户需要查询每个用户的总订单数量,可以使用users表和orders表进行左连接,按用户分组统计订单数量。", "sql": "SELECT u.user_id, u.user_name, COUNT(o.order_id) AS total_orders FROM users u LEFT JOIN orders o ON u.user_id = o.user_id GROUP BY u.user_id LIMIT 50;", "display_type": "response_table" } ERROR!Can not find sql in response
Beta Was this translation helpful? Give feedback.
All reactions