Sql count matching group by

# To count the number of teachers in each department, including 
# rows where COUNT(t.name) == 0
SELECT d.name,COUNT(t.name) FROM teacher t
RIGHT JOIN dept d ON (t.dept=d.id) GROUP BY d.name;

Source: sqlzoo.net

Similar codes

0 vote247 views1 answer
Oracle db get table sizes
SQL
8 votes265 views2 answers
Between operator
SQL
2 votes282 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote259 views1 answer
How to login to mysql in homestead
SQL
0 vote252 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
1 vote260 views3 answers
Nth highest salary
SQL
0 vote608 views1 answer
Sql field equals multiple values
SQL
16 votes258 views2 answers
Add column if not exists mysql
SQL
0 vote267 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
2 votes250 views1 answer
No data found oracle
SQL