Geotab Interview Question

How to write "if" statement in SQL.