if statement in from clause sql code example

Example: if in sql

SELECT 
  IF(500<1000, "YES", "NO");