AlibabaResearch / AlibabaResearch/DAMO-ConvAI
Incorrect gold sql question_id 408
- 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.