A field in a table respectively: id, name, professional. The number of people using SQL query each p-CodePudding

Home > database > A field in a table respectively: id, name, professional. The number of people using SQL query each p

A field in a table respectively: id, name, professional. The number of people using SQL query each p

Time：09-16

A field respectively in the STUDENT table: id, name, professional, the number of people using SQL query each professional

CodePudding user response:

 
Select professional, COUNT (1) the from STUDENT group by professional