爱吃菜叶的猫
爱吃菜叶的猫
全部文章
分类
评论(2)
题解(61)
归档
标签
去牛客网
登录
/
注册
爱吃菜叶的猫的博客
全部文章
(共70篇)
题解 | #某宝店铺折扣率#
SELECT ROUND(SUM(sales_price) / SUM(t_tag_price) * 100, 2) AS 'discount_rate(%)' FROM ( SELECT item_id, sales_num * tag_price AS t_tag_pr...
Mysql
2022-06-20
0
181
题解 | #工作日各时段叫车量、等待接单时间和调度时间#
-- 周一到周五:dayofweek(),其中1表示周日,2表示周一 -- 两个以上分段,用CASE...WHEN... SELECT period, COUNT(1) AS get_car_num, ROUND(AVG(wait_time / 60), 1) AS avg_wait_t...
Mysql
2022-06-19
0
208
题解 | #国庆期间近7日日均取消订单量#
SELECT dt, ROUND(avg_finish_7d, 2) AS finish_num_7d, ROUND(avg_unfinish_7d, 2) AS cancel_num_7d FROM ( SELECT dt, AVG(finish_orde...
Mysql
2022-06-17
0
220
题解 | #每个城市中评分最高的司机信息#
SELECT city, driver_id, avg_grade, avg_order_num, avg_mileage FROM ( SELECT city, driver_id, ROUND(avg_grade, 1) AS ...
Mysql
2022-06-17
0
217
题解 | #有取消订单记录的司机平均评分#
SELECT COALESCE(driver_id, '总体') AS driver_id, ROUND(AVG(grade), 1) AS avg_grade FROM tb_get_car_order WHERE driver_id IN ( SELECT driver_id F...
Mysql
2022-06-17
0
160
题解 | #每个创作者每月的涨粉率及截止当前的总粉丝量#
SELECT city, ROUND(AVG(order_cnt), 3) AS avg_order_num, ROUND(AVG(total_income), 3) AS avg_income FROM ( SELECT driver_id, city, C...
Mysql
2022-06-17
0
201
题解 | #10月的新户客单价和获客成本#
SELECT ROUND(AVG(total_amount), 1) AS avg_amount, ROUND(AVG(cost), 1) AS avg_cost FROM ( SELECT uid, order_id, total_amount, (SUM(pric...
Mysql
2022-05-14
0
214
题解 | #零食类商品中复购率top3高的商品#
SELECT product_id, ROUND(COUNT(IF(purchase_cnt > 1, uid, NULL)) / COUNT(uid), 3) AS repurchase_rate FROM ( SELECT product_id, uid, ...
Mysql
2022-05-14
0
235
题解 | #某店铺的各商品毛利率及店铺整体毛利率#
SELECT product_id, CONCAT(profit_rate, '%') AS profit_rate FROM ( SELECT COALESCE(product_id, '店铺汇总') AS product_id, ROUND((1 - SUM(in...
Mysql
2022-05-13
0
247
题解 | #统计2021年10月每个退货率不大于0.5的商品各项指标#
SELECT product_id, ROUND(COUNT(IF(if_click = 1, product_id, NULL)) / COUNT(event_time), 3) AS ctr, ROUND(COUNT(IF(if_cart = 1, product_id, NU...
Mysql
2022-05-13
0
184
首页
上一页
1
2
3
4
5
6
7
下一页
末页