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 vote239 views1 answer
Oracle list all stored procedures
SQL
0 vote235 views3 answers
Mysql calculate age from date of birth
SQL
0 vote266 views1 answer
Json_remove mysql
SQL
1 vote264 views2 answers
Mysql does sentance contain word
SQL
2 votes284 views1 answer
How to find constraints on a table in oracle
SQL
0 vote260 views1 answer
Oracle list index on table
SQL
0 vote295 views1 answer
ORA-13717
SQL
0 vote292 views1 answer
No query unable to fetch row sqlite
SQL
0 vote279 views1 answer
Docker open terminal mysql server
SQL
0 vote269 views1 answer
Mysql money value
SQL