chenxi6761的博客

从表purchase中提取五月和六月，总gmv中，两个月分别贡献前50%的店铺 表purchase字段说明：ID（店铺ID），name(店铺名)，dt(日期，格式:‘2019-08-25’)，gmv select a.mon, a.name from( select a., @gmv_m:=if(date_format(dt, ‘%Y%m’)=@mon, @gmv_m+gmv, gmv) as g...

求每个部门工资的众数 思路：先求出每个部门每个工资水平的数量，然后求每个部门每个工资数量的最大值，关联，关联条件是同部门工资出现的数量等于工资出现次数的最大值 select a.DepartmentId, a.salary from( select DepartmentId, salary, count(*) as count from Employee group by...

一、 select userid, sum(if(class='文件', count, 0)) as paper, sum(if(class='娱乐', count, 0)) as entertainment, sum(if(class='', count, 0)) as food, max(count) as most_class from( select u...