sql 哪个公司下面车最多？

select COMPANY_ID, count(COMPANY_ID) AS total  FROM gulimall.t_car c group BY COMPANY_ID ORDER by total DESC  ;