Step 1: Select rows where the 'competition' is 'friendly'.
| 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 'venue' is 'shymkent , kazakhstan'.
| date |
venue |
score |
result |
competition |
| 2007-03-07 |
shymkent , kazakhstan |
0 - 1 |
win |
friendly |
| 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 3: Select rows where the 'date' is '2007-06-02'.
| date |
venue |
score |
result |
competition |
| 2007-03-07 |
shymkent , kazakhstan |
0 - 1 |
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 |