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 only
Executed in an isolated in-memory SQLite sandbox against fixture datasets.