Step 1: Select rows where 'date' is '2012-08-15'.
| 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 'score' is '3 - 0'.
| date |
venue |
score |
result |
competition |
| 2012-08-15 |
baku , azerbaijan |
3 - 0 |
win |
friendly |
Step 3: Select rows where 'result' is 'win'.
| date |
venue |
score |
result |
competition |
| 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 |
| 2012-08-15 |
baku , azerbaijan |
3 - 0 |
win |
friendly |