AlibabaResearch / AlibabaResearch/DAMO-ConvAI

Question 180 wrong meaning

未关闭
#218 0 条评论 1 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Python
星标
1.6k
派生
250
PR 合并指标
30 天内没有已合并 PR

描述

"db_id": "financial",

"Please provide a list of clients who were born between 1983 and 1987 and whose account branch is in East Bohemia, along with their IDs."

Grammatically, the sentence reads: "Please provide a list of clients... along with their IDs." * The word "their" refers back to the subject, which is "clients." and not to the account id.

There for the following query is wrong:

"SELECT T1.client_id, T3.account_id FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN disp AS T4 ON T1.client_id = T4.client_id INNER JOIN account AS T3 ON T2.district_id = T3.district_id and T4.account_id = T3.account_id WHERE T2.A3 = 'east Bohemia' AND STRFTIME('%Y', T1.birth_date) BETWEEN '1983' AND '1987'"

贡献指南

这个仓库没有索引到贡献指南

评估

这个 Issue 还没有评估数据。

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。