李齐亮

分类

/ 注册

全部文章（共31篇）

题解 | SQL 186. 牛客直播开始时各直播间在线人数

WITH t1 AS ( SELECT user_id, course_id, TIME(in_datetime), out_datetime FROM attend_tb WHERE TIME(in_date...

2024-12-24

0 44

题解 | SQL 185. 牛客直播转换率

SELECT b.course_id, b.course_name, ROUND(100 * SUM(if_sign) / SUM(if_vw), 2) AS `sign_rate(%)` FROM behavior_tb a LEFT JOIN course...

2024-12-24

0 66

题解 | SQL 184. 某宝店铺连续2天及以上购物的用户及其对应的天数

WITH t1 AS ( SELECT sales_date, user_id, DENSE_RANK() over (PARTITION BY user_id ORDER BY sales_date ASC) AS rank_num FR...

2024-12-24

0 34

题解 | SQL 182. 某宝店铺折扣率

WITH t1 AS ( SELECT a.item_id, a.sales_num, a.sales_price, b.tag_price FROM sales_tb a LEFT JOIN product_...

2024-12-24

0 59

题解 | SQL 181. 某宝店铺的实际销售额与客单价

WITH t1 AS ( SELECT SUM(sales_price) AS sales_total, ROUND( SUM(sales_price) / COUNT(DISTI...

2024-12-24

0 32

题解 | SQL 180. 某宝店铺的SPU数量

SELECT style_id, COUNT(style_id) AS SPU_num FROM product_tb GROUP BY style_id ORDER BY SPU_num DESC;

2024-12-24

0 46

题解 | SQL 183. 某宝店铺动销率与售罄率

WITH b AS ( select item_id, sum(sales_num) as num, sum(sales_price) as item_GMV from ...

2024-12-24

0 34

题解 | SQL 179. 各城市最大同时等车人数

WITH t1 AS( SELECT city, SUM(uv) OVER(PARTITION BY city ORDER BY uv_time,uv DESC) AS uv_cnt #每个城市等车瞬时UV FROM ( SELECT city, even...

2024-12-20

0 34

题解 | SQL 178. 工作日各时段叫车量、等待接单时间和调度时间

WITH t1 AS ( SELECT event_time, CASE WHEN HOUR(event_time) IN (7, 8) THEN '早高峰' WHEN HOUR(event_time) BETWEEN 9 AN...

2024-12-19

0 36

题解 | SQL 177. 国庆期间近7日日均取消订单量

WITH t1 AS ( SELECT DATE (order_time) AS dt, start_time FROM tb_get_car_order HAVING dt BETWEEN '2021-09-25' AND '2021-10-...

2024-12-19

0 67