Your question is SQL Average Salary Query. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
employment_status is Active.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.
| 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 |