Case Statement error (NON- Boolean) : I'm getting error when i tried to use case statement please I'm new in SQL Query anyone know where im wrong 

An expression of non-boolean type specified in a context where a condition is expected, near 'and'.

    case when ("Orcale" and
    "Sqlserver" and "GeoDatabase" and "Shapefile" and "Cadfile" and "Excel" and "Word" and "OtherType") = 0 then 'Re'
    when 
    ("Orcale" and
    "Sqlserver" and "GeoDatabase" and "Shapefile" and "Cadfile" and "Excel" and "Word" and "OtherType") = 1 then 'u'
    end

and how my Database is see the below image

[Data Structure][1]


  [1]: https://i.stack.imgur.com/1kE7P.png