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 |
Prediction: TRUE
Ground-truth: TRUE