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

-1 vote264 views3 answers
PS5
SQL
0 vote190 views1 answer
Turnicate in mysql
SQL
0 vote181 views1 answer
How to get n result in sql
SQL
24 votes199 views5 answers
Import dump mysql
SQL
0 vote198 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote210 views1 answer
How to print sql query
SQL
1 vote209 views1 answer
Oracle compile schema
SQL
0 vote184 views1 answer
Export partttion and import in oracle
SQL
6 votes227 views1 answer
How to get the size of the database in postgresql
SQL
0 vote197 views1 answer
Oracle sql number to varchar2
SQL