用SQL语言找出供应商所在地的数目怎么写

第一 问:查出各供应商的供应商品的数量
答：
select Suppliers.SupplierID as '供应商ID',count(*) as '供应商品的数量' from products inner join suppliers on products.SupplierID = Suppliers.SupplierID group by Suppliers.SupplierID

第二 问
答：
select top 1 Suppliers.SupplierID as '供应商ID',count(*) as 'xxx' from products inner join suppliers on products.SupplierID = Suppliers.SupplierID group by Suppliers.SupplierID order by xxx desc

我测试过，能解决你所提的问题

select 供应商，count(供应商所在地) from t_tableName group by 供应商

select count(distinct 所在地) from 表名