查询字段：book_id，sort_id，当前章节id的uv(uv)，连续章节阅读uv(next_uv)
```
WITH op AS (
SELECT DISTINCT user_id, book_id, sort_id
FROM `fq_chapter_rack_distincts`
WHERE `book_id` = 64 AND `date` >= 20250301 AND `date` <= 20250326
), op1 AS (
SELECT
user_id,
book_id,
sort_id,
LEAD(sort_id, 1, NULL) OVER (PARTITION BY user_id, book_id ORDER BY sort_id) AS next_sort_id
FROM op
)
SELECT
book_id,
sort_id,
COUNT(user_id) AS uv,
COUNT(CASE WHEN next_sort_id IS NOT NULL AND next_sort_id - sort_id = 1 THEN user_id ELSE NULL END) AS next_uv
FROM op1
GROUP BY book_id, sort_id
```
