IIF

1
SELECT
2
  employee_name,
3
  IIF(salary > 50000, 'High', 'Low') AS salary_band
4
FROM employees;

1
SELECT
2
  product_name,
3
  IIF(stock IS NULL OR stock = 0, 'Out of Stock', 'In Stock') AS availability
4
FROM products;

1
SELECT
2
  customer_name,
3
  IIF(vip_status, 'VIP', 'Regular') AS tier,
4
  IIF(total_orders > 10, 'Loyal', 'New') AS loyalty
5
FROM customers;

1
SELECT
2
  department,
3
  SUM(IIF(status = 'active', 1, 0)) AS active_count,
4
  SUM(IIF(status = 'inactive', 1, 0)) AS inactive_count
5
FROM employees
6
GROUP BY department;