Explain OOP and SQL Basics | Dataford Interview Questions

Explain OOP concepts and common SQL commands you would use to query and manipulate data.

Use PostgreSQL syntax and demonstrate the explanation with the supplied departments and employees tables. Return a department-level summary that includes departments without employees.

Output

One row per department with department_name, total_employees, active_employees, avg_active_salary, and staffing_status.
Include all departments, classify staffing status, and sort by active employees descending, average active salary descending, then department name ascending.

Schema

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
department_id	INT	Referenced department identifier
status	VARCHAR(20)	Employee status
salary	NUMERIC(12,2)	Annual salary

Your question is Explain OOP and SQL Basics. Start with the requirements and the two tables 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