**Table X**

```
ColA     ColB      ColC
------------------------
 A       10      Not NULL
 B       20      Not NULL
 C       10      Not NULL
 D       50      Not NULL
 E       20      Not Null

```

I want a statement where `columnB in (10,20)` then return '1' else '0'
Ignore the rest values in ColB

Example output for above table :
1

It should be similar to-

```
Select
case
when ColB is in (10,20) the '1' else '0'
from Table X
where 
ColC is NOT NULL;

```