谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共129篇）

题解 | 获取每个部门中薪水最高的员工相关信息

with total_table as ( select s.emp_no, d_e.dept_no, s.salary, dense_rank() over(partition by d_e.dept_no order by...

2026-01-08

0 13

题解 | 分析每个员工在不同项目中的绩效情况

with first_half_year_projects as ( select * from projects where start_date between '2024-01-01' and ...

2025-07-23

0 43

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

with sales_amount_rank as ( select sp.product_id, pc.product_name, pc.category_id, sp.sales_amount...

2025-07-15

0 53

题解 | 分析每个商品在不同时间段的销售情况

select oi.product_id, pi.product_name, sum(if(order_date between '2024-04-01' and '2024-06-30',total_amount,0)) as...

2025-07-15

0 61

题解 | 电商平台想要了解不同商品在不同月份的销售趋势

select su.product_id, pu.product_name, sum(quantity) as total_sales, max(quantity) as max_monthly_sales, min(q...

2025-07-11

0 52

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

select mu.merchant_id, mu.merchant_name, a.total_sales_amount, b.total_refund_amount, c.average_satisfaction_s...

2025-07-04

0 55

题解 | 对商品的销售情况进行深度分析

select a.product_category, a.age_group, a.total_sales_amount, round(a.total_sales_amount / b.category_sum_amount,2) as...

2025-07-04

1 63

题解 | 最受欢迎的top3课程

select cid, pv, time_len from ( select prt.cid, avg(score) as avg_score, count(if(date(prt.start_t...

2025-07-03

0 66

题解 | 更新员工信息表

select ei.EMPLOYEE_ID, if(ei.LAST_UPDATE_DT < per_eu.UPDATE_DT,per_eu.NEW_POSITION,ei.POSITION) as POSITION, if(ei.LAST_UPD...

2025-07-03

0 70

题解 | 未下单用户登陆渠道统计

select ui.channel, count(ui.channel) as cnt from user_info as ui left join ( select distinct uid from ...

2025-07-03

0 47