title: Conditional value in sqlite column
body: <p>I have two integer columns in my sqlite table: <code>a</code> and <code>b</code>. I need to create a third column, <code>c</code>, which should contain either <code>Y</code> if <code>a+b mod 2 == 1</code> or <code>N</code> if the previous condition is not satisfied. I am not sure how to define such a column with a conditional value in my query.</p>