加油呀加油加油呀

分类

/ 注册

全部文章（共25篇）

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

select dt.emp_no, salary, from_date, dt.to_date, dept_no from dept_manager dt left join salaries s on dt.emp_no = s.emp_no order by s.emp_no asc;

2025-09-02

0 19

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

select emp_no, birth_date, first_name, last_name, gender, hire_date from ( select emp_no, birth_date, first_name, last_name, g...

2025-09-02

0 17

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

select * from employees order by hire_date desc limit 1

2025-09-02

0 24

题解 | 贷款情况

select a.city, total_loan_amount, average_loan_amount, total_customers, most_applied_loan_type from ( select ...

2025-08-01

0 30

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

select name customer_name ,total_travel_cost ,order_count ,avg_order_price from ( select customer_id ,count(*) order_count ,sum(price)...

2025-08-01

0 28

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

select t1.product_id ,product_name ,competitor_name ,total_sales_amount_of_product ,total_sales_amount_of_product - total_competit...

2025-07-30

0 31

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

select product_line ,region ,channel_name ,sum(sale_amount) total_sale_amount ,count(channel_name) total_sale_quantity from sales_...

2025-07-30

0 42

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

# 看准题目 # 条件：配送速度 # 结果：配送时间 select weather_type ,round(avg(delivery_time), 2) average_delivery_time ,count(record_id) delivery_count from d...

2025-07-24

0 23

题解 | 哪些产品在特定时间段内表现最为出色

select product_id, product_name, total_sales_amount, total_sales_quantity from ( select p.product_id, ...

2025-07-22

0 46

题解 | 了解 2023 年全年所有商品的盈利情况

select s.product_id, sum((unit_price - purchase_price) * quantity) total_profit, round( avg((unit_price - purchase_price) / purcha...

2025-07-22

0 26