select company 公司名称,count(*)from goods groupby company;selectcount(*)from goods groupby company;
八 查询京东和淘宝最贵商品的价格
select goodsName,max(price),company 公司名称,count(*)from goods groupby company having company notlike'拼多多';select goodsName,max(price),company 公司名称,count(*)from goods groupby company having company in('京东','淘宝');