select pid,Sum(count) from [表名] group by pid order by sum(count) desc
CREATE TABLE 订单 ( id int(1) NOT NULL , pid varchar(3) NOT NULL , price char(3) NOT NULL , count int(1) NOT NULL PRIMARY KEY (id))
