摘要： sql的分组练习select a.uid , sum(b.score) as total , avg(b.score) as avg_s , count(distinct b.car_id) as count_car from table1 a left join table2 b on a.uid 阅读全文