牛客0501

分类

/ 注册

全部文章（共20篇）

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

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

2025-06-30

0 13

题解 | 查询出每个品牌在不同月份的总销售额以及购买该品牌商品的用户的平均年龄

select category_id, sum(order_amount) total_sales, sum(if(customer_gender = '男',1,0)) male_customers, sum(if(customer_gender = '女',1,0...

2025-06-30

0 10

题解 | 物流公司想要分析快递小哥的薪资构成和绩效情况

select t1.courier_id courier_id, t1.courier_name courier_name, t1.base_salary+t2.s_delivery_fee-t3.s_expense_amount total_income from( ...

2025-06-30

0 6

题解 | 查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分

select t1.brand_id brand_id, t1.brand_name brand_name, round(sum(t2.return_status)/count(t2.return_status),2) return_rate_July_2024, r...

2025-06-30

0 9

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

select em.employee_id employee_id, em.employee_name employee_name, pe.performance_score first_half_2024_score, rank() over(partition b...

2025-06-30

0 8

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

select product_id, product_name, category_id, sales_amount, profit_rate from( select p.product_id product_id, p.product_name product_name, catego...

2025-06-30

0 5

题解 | 统计每个产品的销售情况

select t3.product_id product_id,total_sales,unit_price,total_quantity,avg_monthly_sales,max_monthly_quantity,customer_age_group from (select product_i...

2025-06-23

0 13

题解 | 查询连续登陆的用户

select user_id from( select user_id, max(rk)-min(rk)+1 连续登录 from( select user_id, log_time, row_number() over(partition by use...

2025-06-18

0 15

题解 | 推荐内容准确的用户平均评分

select round(avg(score),3) avg_score from( select distinct user_id, score from recommend_tb re join user_action_tb us on re.rec_user = us.use...

2025-06-18

0 20

题解 | 统计所有课程参加培训人次

select sum(if(course like ('%,%,%'),3,if(course like ('%,%'),2,1))) staff_nums from cultivate_tb where course != 'null'

2025-06-18

0 24