AlibabaResearch / AlibabaResearch/DAMO-ConvAI

Incorrect gold sql question_id 408

Open
#191 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1.6k
Forks
250
PR merge metrics
No merged PRs in 30d

Description

{
"question_id": 408,
"db_id": "card_games",
"question": "How many unknown power cards contain info about the triggered ability",
"evidence": "unknown power cards refers to power is null or power = '\*';contain info about the triggered ability refers to text contains 'triggered ability'",
"SQL": "SELECT T2.text FROM cards AS T1 INNER JOIN rulings AS T2 ON T1.uuid = T2.uuid WHERE (T1.power IS NULL OR T1.power = '*') AND T2.text LIKE '%triggered ability%'",
"difficulty": "moderate"
}

Correct SQL:
SELECT COUNT(\*) FROM cards WHERE (power IS NULL OR power = '\*') AND text LIKE '%triggered ability%';

Justification:
question asks "how many," which refers to Count()

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.