SQL Average Salary Query | Dataford Interview Questions

U.S. Bancorp's workforce reporting team needs the average salary for currently active employees. Write a PostgreSQL query that calculates this single summary value from the employees table.

Requirements

Include only employees whose employment_status is Active.
Return the average of non-NULL salary values in a column named average_salary.

AVG automatically ignores NULL salary values, so employees without a recorded salary should not affect the calculation.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's name
employment_status	VARCHAR(20)	Current employment status
salary	NUMERIC(12,2)	Annual salary in U.S. dollars

Your question is SQL Average Salary Query. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem