SQL Sandbox • SQL
SQL Query Challenge
40:00
SQL Challenges:
SQLite Sandbox Runtime
Challenge 1 of 5EASY
**Average Salary by Department**
Write a SQL query to find the average salary for each department.
Return columns: `department`, `avg_salary` (rounded to nearest integer).
Order by `avg_salary` descending.
Database Tables:
CREATE TABLE departments ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, budget REAL NOT NULL, location TEXT NOT NULL ); CREATE TABLE employees ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, department TEXT NOT NULL, salary REAL NOT NULL, hire_date TEXT NOT NULL, manager_id INTEGER ); CREATE TABLE projects ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, department_id INTEGER, start_date TEXT NOT NULL, end_date TEXT, status TEXT DEFAULT 'active' );
query.sql
SELECT queries onlyExecuted in an isolated in-memory SQLite sandbox against fixture datasets.