马国成好样的

分类

/ 注册

全部文章（共51篇）

题解 | 平均播放进度大于60%的视频类别

select tag ,concat(round(avg(if((timestampdiff(second,start_time,end_time))/duration>=1,1 ,(timestampdiff(second,start_time,end_time))/duration) )*...

2025-07-11

0 31

题解 | 各个视频的平均完播率

select t1.video_id, round(sum(if(timestampdiff(second,start_time,end_time)-duration>=0,1,0))/count(*) ,3) avg_comp_paly_rate from tb_user_video_lo...

2025-07-11

0 48

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

select product_id,product_name,total_sales_amount,total_sales_quantity from ( select s.product_id , product_name , sum(sales_amount) total_sales_amoun...

2025-07-11

0 45

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

select s.product_id , sum((unit_price-purchase_price)*quantity) total_profit , round(sum(unit_price-purchase_price)/sum(purchase_price)*100,2) profit_...

2025-07-11

0 38

题解 | 评估不同供应商提供的零部件质量和成本情况

select supply_quality_cost.supplier_id , supplier_name , component_name , quality_score , cost from supply_quality_cost left join suppliers on suppl...

2025-07-11

0 46

题解 | 物流公司想要分析快递小哥的收入情况

select c.courier_id , courier_name , sum(base_salary+delivery_fee ) total_income from couriers_info c left join (select courier_id,sum(delivery_fee) ...

2025-07-11

1 30

题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况

select e.employee_id , d.department_name , e.performance_score from employee_projects e left join department_info d on e.employee_id = d.employee_id l...

2025-07-11

0 43

题解 | 评估2023年不同品牌商品的销售趋势和客户满意度

with s as( select s.sales_id,brand_id,sales_amount,sales_quantity,satisfaction_score from sales_data s left join customer_feedback c on s.sales_id = c...

2025-07-11

0 40

题解 | 电商平台想要查询出每个商品在 2024 年上半年（1 月至 6 月）的总销售额

select p.product_id ,product_name , sum(quantity*price) total_sales from products_underline p left join ( select product_id,sum(quantity) quantity fro...

2025-07-11

0 40

题解 | 电商平台需要对各行业销售情况综合评估

select industry,sum(sale_amount) total_sales_amount from ( select industry ,sale_amount from merchants_underline m left join sales_underline s on m.me...

2025-07-11

0 36