Case statement not working

I have the following code statement:

SELECT Id, Name, Type,
CASE Type
WHEN Type = 0 THEN 'Public'
WHEN Type = 1 THEN 'Internal'
ELSE 'Unknown'
END as TypeString
FROM table

However, this is resulting like this:
image

Why is this not working?

Please can you upload the query profile ?