SQLite의 조건(condition)문

CASE WHEN first conditional expression THEN column value 
WHEN second conditional expression THEN column value 
WHEN third conditional expression THEN column value 
END 

출처 : http://sqlite.awardspace.info/syntax/sqlitepg09.htm