mysql多个计数写成一行,我们如何使用MySQL合并具有精确计数的同一行？

I have output like this:

number pd_team rating att_attorney law_firm patent_developer

496486 Networks Auto Desai Guntin Wade Walker

520859 Networks Auto Snyder Hanley Wade Walker

449269 Networks Auto Silverman Akerman Wade Walker

526112 Networks Auto Chang Amin; Turocy Wade Walker

558843 Networks Auto Silverman Baker Botts; Wade Walker

403805 Networks Auto Chang Baker Hostetler Wade Walker

264896 Networks Auto Desai Fay Kaplun & Marcin; Wade Walker

228780 Networks Auto Desai Jackson Walker; Wade Walker

534337 Networks Auto Chang Myers Bigel Wade Walker

174237 Networks Auto Desai Scott P. Zimmerman; Dylan Reid

441658 Networks Auto - CON Desai Toler Law Group PC Wade Walker

498561 Networks Auto - CON Chang Tong; Rea; Bentley Wade Walker

452380 Networks Auto Chang Workman Nydegger Wade Walker

The above table is output of an MySQL query what I want actual output is:

count of every field I.e

Network(13)

Auto(11)

Auto-CON(2)

Desai(5)

Snyder(1)

Silverman(2)

Chang(5)

same with other like wade walker(12)

Here is my MySQL query in which there can be multiple entry of filtes and all goes with AND.

SELECT number,salesforce_data.pd_team,salesforce_data.law_firm, salesforce_data.pd_team, salesforce_data.att_attorney,salesforce_data.patent_developer,salesforce_data.rating,salesforce_data.law_firm,salesforce_data.level1_taxonomy FROM application_data INNER JOIN salesforce_data on application_data.application_number= salesforce_data.sf_application_number WHERE salesforce_data.pd_team In ("Networks") AND salesforce_data.ip_manager_rating IN ("Auto","Auto - CON") AND salesforce_data.status="Filed"

Snapshot:

解决方案

Try this query.

select t1.name Value, count(t1.name) Count from(

select pd_team from Table

union all

select rating from Table

union all

select att_attorney from Table

union all

select law_firm from Table

union all

select patent_developer from Table) t1 group by t1.name;