AlibabaResearch / AlibabaResearch/DAMO-ConvAI
Incorrect gold sql question_id 408
- Langage dominant
- Python
- Étoiles
- 1.6k
- Forks
- 250
- Métriques de merge des PR
- Aucune PR mergée en 30 j
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()
Guide de contribution
Aucun guide de contribution indexé pour ce dépôt
Évaluation
Cette issue n'a pas encore été évaluée.