牛客752205773号

分类

题解(55)

/ 注册

全部文章（共42篇）

题解 | #牛客的课程订单分析(七)#

select ifnull(t3.name,'GroupBuy'), count(*) from (select t1.user_id, t1.client_id from ( select *,count(id) over(partition by user_id) as number,...

Mysql

2022-06-28

0 212

题解 | #牛客的课程订单分析(六)#

select t.id,t.is_group_buy,t.name from( select a.id,a.is_group_buy,b.name, count(a.id)over(partition by a.user_id) ct from order_info a left join clie...

Mysql

2022-06-28

0 248

题解 | #牛客的课程订单分析(四)#

select t1.user_id, min(t1.date),t1.number from ( select *,count(id) over(partition by user_id) as number from order_info where datediff(da...

Mysql

2022-06-28

0 241

题解 | #牛客的课程订单分析(三)#

select t1.id, t1.user_id,t1.product_name,t1.status,t1.client_id,t1.date from ( select *,count(id) over(partition by user_id) as number from or...

Mysql

2022-06-28

0 198

题解 | #牛客的课程订单分析(二)#

select b.user_id from( select a.user_id, count(a.user_id)over(partition by a.user_id) ct from order_info a where a.date > '2025-10-15' ...

Mysql

2022-06-28

0 199

题解 | #统计salary的累计和running_total#

select t.emp_no, t.salary, sum(salary)over(order by t.emp_no) running_total from salaries t where t.to_date='9999=-01-01' 或 select t1.emp_no, t1.salar...

Mysql

2022-06-24

0 254

题解 | #获取有奖金的员工相关信息。#

select t.emp_no, t2.first_name, t2.last_name, t1.btype, t.salary, case when t1.btype=1 then t.salary*0.1 when t1.btype=2 then t.salary*0.2 e...

Mysql

2022-06-24

0 242

题解 | #使用含有关键字exists查找未分配具体部门的员工的所有信息。#

select c.emp_no, c.birth_date, c.first_name, c.last_name, c.gender, c.hire_date from( select a.emp_no, a.birth_date, a.first_name, a.last_...

Mysql

2022-06-24

0 245

题解 | #平均工资#

select (t.a-t.b-t.c)/(t.d-2) from(select sum(salary) a, min(salary) b, max(salary) c, count(salary) d from s...

Mysql

2022-06-23

0 242

题解 | #平均工资#

select (t.a-t.b-t.c)/(t.d-2) from(select sum(salary) a, min(salary) b, max(salary) c, count(salary) d from s...

Mysql

2022-06-23

0 238