The `CASE` statement allows for some basic logic in SQL.
```SQL
SElECT columnA, columnB,
CASE
WHEN <condition1> THEN <result1>
WHEN <condition2> THEN <result2>
ELSE <defaultResult> -- optional
END <returnColumn>
FROM <table>
```
As always, use single quotes for strings in the result. Make sure a comma separates the other columns in the query.