牛客593719959号

题解

/ 注册

全部文章 / 题解（共56篇）

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

sql script -- user buy more than 2 select user_id, count(product_name) as cnt from order_info where date >= '2025-10-15' and status='completed' an...

sql

2021-09-11

1 308

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

sql script -- user buy more than 2 # select user_id, count(product_name) as cnt # from order_info # where date >= '2025-10-15' # and status='compl...

sql

2021-09-11

0 368

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

sql script select * from order_info where user_id in (select user_id from order_info where date >= '2025-10-1...

sql

2021-09-11

0 329

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

sql script select user_id from order_info where date >= '2025-10-15' and status='completed' and product_name in ('C++', 'Java', 'Python') group by...

sql

2021-09-11

0 277

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

sql script select * from order_info where date >= '2025-10-15' and `status`='completed' and product_name in ('C++', 'Java', 'Python')

sql

2021-09-11

0 334

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

sql script -- find numbers of job # select id, job, count(job) as max_number # from grade # group by job -- rank # select id, job, rank() over(par...

sql

2021-09-11

0 320

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

sql script select job, case when count(job) % 2=0 then round(count(job)/2,0) when count(job) % 2!=0 then round(ceil(count(job)/2),0) end as star...

sql

2021-09-11

0 360

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

sql script select tmp.id, l.name, tmp.score from (select id, language_id, dense_rank() over(partition by language_id order by score desc) as rank_s, ...

sql

2021-09-11

0 439

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

sql script select g.id, g.job, g.score from (select job, avg(score) as avg_score from grade group by job) tmp, grade g where tmp.job=g.jo...

sql

2021-09-10

0 286

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

sql script select job, round(avg(score),3) as `avg` from grade group by job order by `avg` desc

sql

2021-09-10

0 283