Step 1: Select rows where 'name' is 'paulo costa'.
| nat |
name |
moving_to |
type |
transfer_window |
transfer_fee |
source |
| gre |
machlas |
retired |
retirement |
summer |
- |
contragr |
| cyp |
makrides |
metalurh donetsk |
end of contract |
summer |
free |
kerkidanet |
| ser |
čorović |
ael limassol |
loan return |
summer |
- |
- |
| cyp |
louka |
ael limassol |
end of contract |
summer |
free |
kerkidanet |
| gre |
kapsis |
levadiakos |
end of contract |
summer |
free |
- |
| cyp |
daskalakis |
aek larnaca |
end of contract |
summer |
free |
apoelnet |
| bra |
zé carlos |
trofense |
contract termination |
summer |
free |
apoelfccomcy |
| cyp |
vourkou |
doxa katokopia |
loan |
summer |
free |
- |
| cyp |
panayiotou |
digenis morphou |
loan |
summer |
free |
- |
| mkd |
nikolovski |
aep paphos |
mutual consent |
winter |
free |
- |
| cyp |
papathanasiou |
ermis aradippou |
loan |
winter |
free |
- |
| por |
paulo costa |
anorthosis famagusta |
mutual consent loan return |
winter |
free |
apoelfccomcy |
Step 2: Select rows where 'type' is 'retirement'.
| nat |
name |
moving_to |
type |
transfer_window |
transfer_fee |
source |
| por |
paulo costa |
anorthosis famagusta |
mutual consent loan return |
winter |
free |
apoelfccomcy |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| nat |
name |
moving_to |
type |
transfer_window |
transfer_fee |
source |
Final output table:
| verification_result |
| FALSE |
Prediction: FALSE
Ground-truth: FALSE