Step 1: Select rows where the 'result' is 'win'.
date |
venue |
score |
result |
competition |
2007-03-07 |
shymkent , kazakhstan |
0 - 1 |
win |
friendly |
2007-06-02 |
baku , azerbaijan |
1 - 3 |
lost |
uefa euro 2008 qualifying |
2007-08-22 |
dushanbe , tajikistan |
2 - 3 |
win |
friendly |
2007-09-12 |
baku , azerbaijan |
1 - 1 |
draw |
friendly |
2008-06-04 |
andorra la vella , andorra |
1 - 2 |
win |
friendly |
2008-11-19 |
baku , azerbaijan |
1 - 1 |
draw |
friendly |
2012-08-15 |
baku , azerbaijan |
3 - 0 |
win |
friendly |
Step 2: Select rows where the 'competition' is 'friendly'.
date |
venue |
score |
result |
competition |
2007-03-07 |
shymkent , kazakhstan |
0 - 1 |
win |
friendly |
2007-08-22 |
dushanbe , tajikistan |
2 - 3 |
win |
friendly |
2008-06-04 |
andorra la vella , andorra |
1 - 2 |
win |
friendly |
2012-08-15 |
baku , azerbaijan |
3 - 0 |
win |
friendly |
Step 3: Select rows where the 'date' is '2007-06-02'.
date |
venue |
score |
result |
competition |
2007-03-07 |
shymkent , kazakhstan |
0 - 1 |
win |
friendly |
2007-08-22 |
dushanbe , tajikistan |
2 - 3 |
win |
friendly |
2008-06-04 |
andorra la vella , andorra |
1 - 2 |
win |
friendly |
2012-08-15 |
baku , azerbaijan |
3 - 0 |
win |
friendly |
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 |
verification_result |
FALSE |