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 vote105 views1 answer
Sql headers delphi
SQL
0 vote127 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote119 views1 answer
How to find unique element in sql
SQL
0 vote104 views1 answer
Group_concat only returns one row
SQL
2 votes111 views1 answer
Copy all values of a column to another column in sql in same table
SQL
11 votes173 views3 answers
Pl sql example
SQL
0 vote134 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
1 vote108 views1 answer
Delete row mssql
SQL
0 vote128 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote104 views1 answer
How to connect pgadmin with excel
SQL