title: How to use SQL if -then -else statement to create/derive a new column
body: <p>how should the script be like if I want a column 'Before 10am' to be 1 if the column 'Time' is &lt;=10:00:00, else it will be 0? Thanks.</p>