Step 1: Order the table by 'year' in descending order.
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: Select the last two rows from the ordered table.
year |
competition |
venue |
position |
notes |
2013-01-01 |
world championships |
moscow , russia |
3rd |
79.36 m |
2012-01-01 |
olympic games |
london , great britain |
6th |
77.17 m |
2009-01-01 |
world championships |
berlin , germany |
14th |
74.47 m |
2008-01-01 |
olympic games |
beijing , pr china |
29th |
70.56 m |
2006-01-01 |
european championships |
gothenburg , sweden |
15th |
73.77 m |
2005-01-01 |
world championships |
helsinki , finland |
14th |
74.53 m |
2003-01-01 |
universiade |
daegu , south korea |
4th |
71.26 m |
2001-01-01 |
european u23 championships |
amsterdam , netherlands |
11th |
66.41 m |
1999-01-01 |
european junior championships |
riga , latvia |
5th |
64.20 m |
1998-01-01 |
world junior championships |
annecy , france |
10th |
61.51 m |
Step 3: Extract the numerical distance from the 'notes' column then add column 'distance' to the selected rows.
year |
competition |
venue |
position |
notes |
2013-01-01 |
world championships |
moscow , russia |
3rd |
79.36 m |
2012-01-01 |
olympic games |
london , great britain |
6th |
77.17 m |
Step 4: Calculate the average distance of the selected rows.
year |
competition |
venue |
position |
notes |
distance |
2013-01-01 |
world championships |
moscow , russia |
3rd |
79.36 m |
79.36 |
2012-01-01 |
olympic games |
london , great britain |
6th |
77.17 m |
77.17 |
Step 5: Use a `CASE` statement to return TRUE if the average distance is equal to 78.27 m, otherwise return FALSE.
avg_distance |
verification_result |
78.265 |
TRUE |