AlibabaResearch / AlibabaResearch/DAMO-ConvAI
[Clarification] Question id 443 dev set
- 主要语言
- Python
- 星标
- 1.6k
- 派生
- 250
- PR 合并指标
- 30 天内没有已合并 PR
描述
Hi Bird team,
In question 443 in the dev set (“Give the code of sets that have expansion type ‘expansion’?”) for the “card_games” database, the gold SQL is:
SELECT T2.setCode
FROM sets AS T1
INNER JOIN set_translations AS T2 ON T2.setCode = T1.code
WHERE T1.type = 'expansion'
GROUP BY T2.setCode;
Could you clarify why joining to set_translations is necessary here?
The sets table already contains a `code` column whose description matches “setCode”, and the question does not ask for translations. Is the join required only to satisfy an annotation/evidence mapping that expects the output column name to be `setCode`, or is there a data rule that a set code is only considered valid if it appears in set_translations?
Thanks!
贡献指南
这个仓库没有索引到贡献指南
评估
这个 Issue 还没有评估数据。