SQL Server Exercise

The value of n in the same classification is added to the value of M:


1 SelectSub-category, Man=sum(Number of numbers) fromAwhere(Name='m' ORName='N') and2 3Sub-categoryinch(4 --Groups with M and N have at least one group5 SelectAn. Sub-category from6 (7 SelectSub-category, Countm from8(SelectSub-category, Countm=Count(name) fromAwhereName='m' Group  bycategory) cm9 whereCm.countm>=1 Ten) am Right Join One  A ( - SelectSub-category, COUNTN from -(SelectSub-category, COUNTN=Count(name) fromAwhereName='N' Group  bycategory) CN the whereCn.countn>=1  -) an onAn. Sub-category=am. Classification) -  - Group  bySub-category

SQL Server Exercise