or condition if if statment in sql code example

Example: if in sql

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