题解 | 计算男生人数以及平均GPA
计算男生人数以及平均GPA
https://www.nowcoder.com/practice/7d9a7b2d6b4241dbb5e5066d7549ca01
select count(*) as male_num,avg(gpa) as avg_gpa from user_profile group by gender having gender='male'; 优先级:where groupby having
计算男生人数以及平均GPA
https://www.nowcoder.com/practice/7d9a7b2d6b4241dbb5e5066d7549ca01
select count(*) as male_num,avg(gpa) as avg_gpa from user_profile group by gender having gender='male'; 优先级:where groupby having
相关推荐
李橙子:你这如果想找java方向的,那你的项目就不要写python啊,不然会以为你是主要找python的