Liumankit

分类

/ 注册

全部文章（共23篇）

题解 | 某乎问答11月份日人均回答量

select date(answer_date), round(count(issue_id) / count(distinct author_id) ,2) from answer_tb where date_format(answer_date, '%Y-%m') = '2021-11' gro...

2025-08-05

0 24

题解 | 2021年国庆在北京接单3次及以上的司机统计信息

select city, round(avg(bill_count),3) as avg_order_num, round(avg(fare),3) as avg_income from ( select city, a.driver_id, count(*) as bill_count, sum...

2025-08-04

0 23

题解 | 2021年11月每天的人均浏览文章时长

select single_date, round(avg(per_day_time),1) as avg_viiew_len_sec # round(sum(per_day_time) / count(*),1) from( select uid, date(in_time) as single...

2025-08-04

0 20