数分菜鸟求职ing

分类

/ 注册

全部文章（共75篇）

将employees表的所有员工的last_name和first_name拼接起来作为Name

select concat(last_name,' ',first_name) name from employees

2026-01-28

0 11

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

select title,description from film f left join film_category fc on f.film_id = fc.film_id left join category c on fc.category_id = c.category_id where...

2026-01-28

0 15

题解 | 使用join查询方式找出没有分类的电影id以及名称

select f.film_id,title from film f left join film_category fc on f.film_id = fc.film_id where category_id is null

2026-01-28

0 15

题解 | 汇总各个部门当前员工的title类型的分配数目

select de.dept_no,dept_name,title,count(t.emp_no) count from departments d left join dept_emp de on d.dept_no = de.dept_no left join titles t on de.em...

2026-01-28

0 10

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

select de.emp_no,dm.emp_no,s1.salary,s2.salary from dept_emp de join dept_manager dm on de.dept_no = dm.dept_no join salaries s1 on de.emp_no = s1.emp...

2026-01-27

0 17

题解 | 对所有员工的薪水按照salary降序进行1-N的排名

这样OK不 select emp_no,salary,dense_rank()over(order by salary desc) t_rank from salaries s

2026-01-26

0 14

题解 | 目标月份的品类销售简报

大厂笔试SQL刷完了祝我找份合适的工作 with t1 as( select category,count(distinct oi.order_id) orders_cnt, count(distinct buyer_id) buyers_cnt, sum(qty) ite...

2026-01-11

0 36

题解 | 统计创作者

with t1 as ( select post_id,author_id,publish_ts, rank()over(partition by author_id order by publish_ts desc) rk from post ), time1 as ( ...

2026-01-09

0 33

题解 | 统计每个班级的关键指标

分表分的有点麻烦 t1和t2还能在处理一下 with t1 as ( select student_id,class_id,lesson_id,watch_minutes,finished_flag,log_ts from study_logs_ where finishe...

2026-01-09

0 30

题解 | 下单复盘

with feb as ( select o.order_id,customer_id,order_date,sku,qty,price from order_items oi join orders o on oi.order_id = o.order_id where o...

2026-01-05

0 33