我不打朋友圈

题解

/ 注册

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

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

select t.id,t.user_id,t.product_name,t.status,t.client_id,t.date from ( select ,count() over(partition by user_id) as num from order_info where produc...

Sqlite

2021-12-17

0 323

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

select user_id from (select user_id,count(user_id) as ui from order_info where date >'2025-10-15' and product_name in ('C++','Java','Python') and s...

Sqlite

2021-12-17

0 265

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

select gr.id,gr.job,gr.score from grade gr, (select job,avg(score) as score from grade group by job) b where gr.job = b.job and gr.score > b.score ...

Sqlite

2021-12-17

0 294

题解 | #平均工资#

select avg(salary) from salaries where to_date = '9999-01-01' and salary != (select max(salary) from salaries where to_date = '9999-01-01') and salar...

Sqlite

2021-12-17

0 236