想到就去做

分类

题解(78)

/ 注册

全部文章（共41篇）

题解 | #查找描述信息中包含robot的电影对应的分类名称以及电影数目，而且还需要该分类对应电影数量>=5部#

select c.name,count(f.film_id) cntfrom film f,film_category fc,category cwhere f.description like '%robot%'and f.film_id = fc.film_idand c.category_id...

2021-09-10

1 279

题解 | #获取每个部门中当前员工薪水最高的相关信息#

select a.date,(case when c.next_u is null then 0.000 else round(c.next_u/b.new_u,3) end) p from...

2021-09-10

0 351

题解 | #实习广场投递简历分析(三)#

select f.job,f.mon first_year_mon,f.cnt first_year_cnt, s.mon second_year_mon,s.cnt second_year_cntfrom (select job,left(date,7) mon,sum(num) cn...

2021-09-09

1 371

题解 | #考试分数(三)#

select id,name,scorefrom (select g.id,name,score, dense_rank()over(partition by language_id order by score desc) rk from grade g left join l...

2021-09-09

1 316

题解 | #查找在职员工自入职以来的薪水涨幅情况#

select z.emp_no,(z.salary-r.salary) growthfrom (select s.emp_no,salary from salaries s where to_date = '9999-01-01') z inner join (...

2021-09-09

1 303

题解 | #考试分数(五)#

select id,job,score,t_rankfrom (select ,row_number()over(partition by job order by score desc) t_rank, count()over(partition by job) n ...

2021-09-09

1 315

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

select user_id,min(date)over(partition by user_id) first_buy_date, d2 second_buy_date, cntfrom (select ,lead(date,1)over(partition by user...

2021-09-09

1 349

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

select a.id,a.is_group_buy,c.namefrom (select ,count()over(partition by user_id) cnt from order_info o where date > '2025-10-15' and...

2021-09-09

1 411

题解 | #最差是第几名(二)#

(select gradefrom (select grade,sum(number)over(order by grade) s1, sum(number)over() / 2 m from class_grade order by grade) awhere a.s1 >...

2021-09-08

2 436

题解 | #获得积分最多的人(三)#

select round(count(distinct case when datediff(b.date, a.date) = 1 then a.user_id end) / count(distinct a.user_...

2021-09-07

0 277