select b.物料类型,count(distinct a.物料号) as 面料数
from 物料清单表 as a
left join 面料信息表 as b
on a.物料号=b.物料号
where a.设计师=01
group by b.物料类型
order by 面料数 desc;