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 vote329 views1 answer
Trim sql oracle
SQL
17 votes368 views6 answers
What is cursor in sql server with example
SQL
0 vote342 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote351 views1 answer
Do postgresql
SQL
0 vote343 views1 answer
Reset keys in sql
SQL
0 vote328 views1 answer
Oracle sqlp update amount / quantity
SQL
-1 vote330 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
3 votes483 views1 answer
How to get yesterday date in sql
SQL
0 vote370 views1 answer
Mysql remove bad character from all fields
SQL
0 vote355 views1 answer
Mysql isshow
SQL