Step 1: Select rows where 'competition' is '2010 world cup qualification'.
| date |
venue |
score |
result |
competition |
| 2008-02-02 |
seoul , south korea |
1 - 0 |
4 - 0 |
2010 world cup qualification |
| 2008-02-17 |
chongqing , china |
3 - 2 |
3 - 2 |
2008 east asian cup |
| 2008-10-15 |
seoul , south korea |
4 - 1 |
4 - 1 |
2010 world cup qualification |
| 2010-03-03 |
london , england |
2 - 0 |
2 - 0 |
friendly |
| 2012-06-08 |
doha , qatar |
2 - 1 |
4 - 1 |
2014 world cup qualification |
Step 2: Select rows where 'score' is '2 - 1'.
| date |
venue |
score |
result |
competition |
| 2008-02-02 |
seoul , south korea |
1 - 0 |
4 - 0 |
2010 world cup qualification |
| 2008-10-15 |
seoul , south korea |
4 - 1 |
4 - 1 |
2010 world cup qualification |
Step 3: Select rows where 'venue' is 'seoul , south korea'.
| date |
venue |
score |
result |
competition |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| date |
venue |
score |
result |
competition |