Can you implement a SQL statement to count how many teachers there are in each department? For example, you can generate

etyler

Find a SQL statement:

Table A: eis_dict_depart records the teacher department name

i_code c_name
  1 Principal's Office
  2 Teaching Office
 ........


Table B: eis_tech_info records all teacher information (id: automatic number; techname: teacher name; departid: department number)

id techname departid
1 sheet three 1
2 Reese 2
3 King 2 2
4 Mazi 2
........


Can you implement a SQL statement to count how many teachers there are in each department? For example, you can generate the following table

c_name total
Principal's office 1
Teaching Office 3

ryd1986

select c_name, count (*) from (select t.techname, t.departid, d.c_name
 from tech_info t left join in depart d on t.departid = d.departid) a group by t.t.departid, t.c_name

养狗的上帝

SELECT COUNT (*) AS techCount, c_Name
FROM eis_tech_info INNER JOIN eis_dict_depart ON
       eis_tech_info.departid = eis_dict_depart.i_code
GROUP BY eis_tech_info.departid

养狗的上帝

It is recommended to look at the online help of SQL Server, these are too simple.

ryd1986

select c_name, count (*) from (select t.techname, t.departid, d.c_name
 from dbo.eis_tech_info t left join dbo.eis_dict_depart d on t.departid = d.i_code) a group by departid, c_name

ryd1986

The code has been tested. You can use it directly