allison0010

分类

题解(3)

/ 注册

全部文章（共4篇）

题解 | #统计每个用户的平均刷题数#

select up.university,qd.difficult_level, count(qpd.question_id)/count(distinct up.device_id) as avg_answer_cnt from user_profile as up inner join qu...

2023-03-17

0 192

题解 | #统计每个学校各难度的用户平均刷题数#

select up.university,qd.difficult_level, count(qpd.question_id)/count(distinct up.device_id) from user_profile as up inner join question_practice_det...

2023-03-17

0 234

题解 | #统计每个学校的答过题的用户的平均答题数#

select university,count(qp.question_id)/count(distinct up.device_id) as avg_answer_cnt from user_profile as up inner join question_practice_detail ...

2023-03-17

0 281

题解 | #统计文件的行数#

1、先使用grep -n 打印出文件的行号2、再使用tail 打印出最后一行3、接着使用awk打印出第一列就是行数，命令如下 grep -n '.*' nowcoder.txt | tail -n 1 | awk -F : '{print $1}'

2021-07-09

14 1172