Step 1: Select rows where the 'result' is '3 - 2'.
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 the 'score' is '2 - 0'.
date |
venue |
score |
result |
competition |
2008-02-17 |
chongqing , china |
3 - 2 |
3 - 2 |
2008 east asian cup |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date |
venue |
score |
result |
competition |