Plan-of-SQLs (Ours)


Statement: four of the competitions out of ten were world wide championships

Ground-truth: TRUE

Input Table: lukáš melich

Step 1: Select rows where 'competition' contains the word "world".
year competition venue position notes
1998-01-01 world junior championships annecy , france 10th 61.51 m
1999-01-01 european junior championships riga , latvia 5th 64.20 m
2001-01-01 european u23 championships amsterdam , netherlands 11th 66.41 m
2003-01-01 universiade daegu , south korea 4th 71.26 m
2005-01-01 world championships helsinki , finland 14th 74.53 m
2006-01-01 european championships gothenburg , sweden 15th 73.77 m
2008-01-01 olympic games beijing , pr china 29th 70.56 m
2009-01-01 world championships berlin , germany 14th 74.47 m
2012-01-01 olympic games london , great britain 6th 77.17 m
2013-01-01 world championships moscow , russia 3rd 79.36 m

Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 4, otherwise return FALSE.
year competition venue position notes
1998-01-01 world junior championships annecy , france 10th 61.51 m
2005-01-01 world championships helsinki , finland 14th 74.53 m
2009-01-01 world championships berlin , germany 14th 74.47 m
2013-01-01 world championships moscow , russia 3rd 79.36 m

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE