爱吃菜叶的猫
爱吃菜叶的猫
全部文章
题解
评论(2)
归档
标签
去牛客网
登录
/
注册
爱吃菜叶的猫的博客
全部文章
/ 题解
(共61篇)
题解 | #牛客直播转换率#
SELECT course_id, course_name, ROUND(COUNT(DISTINCT IF(if_sign = 1, user_id, NULL)) / COUNT(DISTINCT IF(if_vw = 1, user_id, NULL)) * 100, 2) AS ...
Mysql
2022-06-22
0
193
题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
SELECT user_id, MAX(diff_rank) AS days_count FROM ( SELECT user_id, DATE_SUB(sales_date, INTERVAL date_rank DAY) AS dt, DENSE_...
Mysql
2022-06-22
0
193
题解 | #某宝店铺动销率与售罄率#
SELECT style_id, ROUND(IFNULL(total_sales_num, 0) / (total_inventory - total_sales_num) * 100, 2) AS 'pin_rate(%)', ROUND(GVM / inventory_valu...
Mysql
2022-06-20
0
156
题解 | #某宝店铺折扣率#
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
183
题解 | #工作日各时段叫车量、等待接单时间和调度时间#
-- 周一到周五: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
首页
上一页
1
2
3
4
5
6
7
下一页
末页