SQLForge PRO — Relational Practice Platform

-- Chapter 1 Practice: SELECT & Projections
CREATE TABLE employees (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  department TEXT NOT NULL,
  salary INTEGER NOT NULL
);

INSERT INTO employees VALUES
  (1, 'Alice Chen', 'Engineering', 125000),
  (2, 'Marcus Brody', 'Product', 110000),
  (3, 'Sarah Connor', 'Engineering', 135000);

-- Problem: Query deduplicated departments and average salaries
SELECT department, AVG(salary) AS avg_sal
FROM employees
GROUP BY department
HAVING avg_sal > 100000;