AlibabaResearch / AlibabaResearch/DAMO-ConvAI

[Clarification] Question id 443 dev set

未关闭
#219 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
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 还没有评估数据。

把新 issue 发到你的邮箱

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