存几分期许

分类

/ 注册

全部文章（共167篇）

题解 | 查找所有员工的last_name和first_name以及对应部门编号dept_no

select last_name, first_name, dept_no from employees a left join dept_emp b on a.emp_no=b.emp_no

2025-08-14

0 43

题解 | 查找所有已经分配部门的员工的last_name和first_name以及dept_no

select last_name, first_name, dept_no from employees a join dept_emp b on a.emp_no=b.emp_no

2025-08-14

0 29

题解 | 查找当前薪水详情以及部门编号dept_no

select a.emp_no, salary, from_date, a.to_date, dept_no from salaries a join dept_manager b on a.emp_no=b.emp_no order by a.emp_no

2025-08-14

0 29

题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息

select emp_no, birth_date, first_name, last_name, gender, hire_date from ( select *, dense_rank() over (order by hire_date desc) as dr fro...

2025-08-14

0 37

题解 | 查找最晚入职员工的所有信息

select * from employees order by hire_date desc limit 1

2025-08-14

0 26

题解 | 贷款情况

with t as ( select city, a.customer_id, loan_amount, d.loan_type_id, loan_type_name, count(1) over (partition by city, loan_type_name) as cnt ...

2025-08-14

0 49

题解 | 查询高价值旅行套餐客户的支出与套餐详情

select c.name as customer_name, sum(price) as total_travel_cost, count(1) as order_count, round(sum(price)/count(1), 2) as avg_order_price from bookin...

2025-08-14

0 35

题解 | 分析各产品线在特定时间段内的销售情况

select b.product_line, region, channel_name, sum(sale_amount) as total_sale_amount, count(1) as total_sale_quantity from sales_data a join oppo_produc...

2025-08-14

0 29

题解 | 深入分析各款产品年总销售额与竞品的年度对比

select b.product_id, product_name, competitor_name, total_sales_amount_of_product, total_sales_amount_of_product-total_competitor_sales_amount_2023 a...

2025-08-13

0 37

题解 | 饿了么需要分析不同配送员在不同天气条件下的配送效率和用户投诉情况

with t1 as ( select * from ( select staff_id, weather_id, sum(case when is_complaint=1 then 1 else 0 end)/count(1) as complain...

2025-08-13

0 51