I have a table like the following:

| AGE | CARD | SCORE |
| --- | --- | --- |
| 10 | 1 | 20000 |
| 18 | 1 | 3000 |
| 25 | 0 | 2000 |

I want to add the "Status" column fulfilling all of the conditions; AGE>17, CARD = 1, and SCORE>2200.

| AGE | CARD | SCORE | STATUS |
| --- | --- | --- | --- |
| 10 | 1 | 20000 | 0 |
| 18 | 1 | 3000 | 1 |
| 25 | 0 | 2000 | 0 |