>_
SQL Practice Ground
Challenges
Practice
Playground
Sign in
SQL Playground
SQLite 3
PostgreSQL 17
MySQL 8 (soon)
Save
Run
Schema SQL
create table employees ( id integer primary key, name text not null, dept text, salary integer ); insert into employees values (1, 'Ada', 'Engineering', 120000), (2, 'Grace', 'Engineering', 135000), (3, 'Linus', 'Ops', 98000), (4, 'Edsger', 'Research', 110000);
Query SQL · Ctrl+Enter to run
select dept, count(*) as people, avg(salary) as avg_salary from employees group by dept order by avg_salary desc;
Explain an error
Press Run to see results here.