IntermediateBasic SELECT

Select employees using NULLIF to avoid division by zero

The query

SQL

SELECT
  emp_id,
  first_name,
  hours_worked,
  total_pay,
  ROUND(total_pay / NULLIF(hours_worked, 0), 2) AS hourly_rate
FROM employees;

Tested against PostgreSQL 16

Note

“NULLIF(x, 0) returns NULL if x=0, preventing division-by-zero errors.