在单个查询中进行分组，排序和计数

仅是我对您要求的http://sqlfiddle.com/#!9/e9206/16的猜测

因为它带来了预期的结果：

 SELECt A.family, C.NbrFamily,A.sub_family,B.NbrSubFamily,A.name,COUNT(A.Name) FROM  commodities as ALEFT JOIN (  SELECt family,sub_family,COUNT(Name) AS NbrSubFamily   FROM commodities   GROUP BY family,sub_family) BON A.sub_family = B.sub_family   AND A.family = B.family LEFT JOIN (  SELECt family,COUNT(Name) AS NbrFamily   FROM commodities   GROUP BY family) CON  A.family = C.family GROUP BY A.family,A.sub_family,A.nameORDER BY A.id