牛客666375956号

分类

题解(56)

/ 注册

全部文章（共51篇）

题解 | #商品交易(网易校招笔试真题)#

SELECT goods.*,t.total FROM goods,(SELECT trans.goods_id,sum(trans.count) total FROM trans GROUP BY trans.goods_id) t where goods.id = t.goods_id and ...

Mysql

2021-12-25

0 194

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

先按用户id进行分组计算sum，然后排序后去第一行，再跟另一个表进行连接 select user.name,t.grade_sum from (select user_id,sum(grade_num) as grade_sum from grade_info group by user_id or...

Mysql

2021-12-25

0 211

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

case when SELECT grade ,CASE grade WHEN 'A' THEN(SELECT SUM(number) FROM class_grade WHERE grade <='A') ...

Mysql

2021-12-25

0 233

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

select job,date_format(date,'%Y-%m') as mon,sum(num) as cnt from resume_info where date_format(date,'%Y')=2025 group by job,date_format(date,'%Y-%m') ...

Mysql

2021-12-25

0 269

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

FROM (SELECT * from order_info where user_id IN (SELECT user_id from order_info where date>"2025-10-15" and status ="completed" an...

Mysql

2021-12-25

0 230

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

from order_info where user_id IN (SELECT user_id from order_info where date>"2025-10-15" and status ="completed" and product_name ...

Mysql

2021-12-25

0 255

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

FROM grade g,(SELECT job,avg(score) as score from grade group by job)a where g.score > a.score and g.job=a.job order by g.id;

Mysql

2021-12-25

0 204

题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#

from film where film_id in (select film_id from category c inner join film_category fc on c.category_id=fc.category_id ...

Mysql

2021-12-24

0 189

题解 | #将titles_test表名修改为titles_2017#

from film where film_id not in (select film_id from category c inner join film_category as fc on c.category_id=fc.category_id)

Mysql

2021-12-24

0 213

题解 | #统计各个部门的工资记录数#

SELECT d.dept_no,d.dept_name,COUNT(d.dept_name) sum FROM (SELECT c.dept_no,s.salary FROM dept_emp c RIGHT JOIN salaries s on c.emp_no=s....

Mysql

2021-11-04

0 219