积极的六边形战士G了

分类

/ 注册

全部文章（共30篇）

题解 | #计算用户8月每天的练题数量#

select day(date) as day, count(question_id) as question_cnt from question_practice_detail where month(date)=8 and year(date)=2021 group by date

2023-09-23

0 127

题解 | #查看不同年龄段的用户明细#

select device_id, gender, case when age>=25 then '25岁及以上' when age>=20 then '20-24岁' when age<20 then '20岁以下' ...

2023-09-23

1 155

题解 | #查找山东大学或者性别为男生的信息#

select device_id, gender, age, gpa from user_profile where university = '山东大学' union all select device_id, gender, age, gpa from user_profile where g...

2023-09-23

0 152

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

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

2023-09-23

0 109

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

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

2023-09-23

0 144

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

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

2023-09-23

0 143

题解 | #分组排序练习题#

select university, avg(question_cnt) as avg_question_cnt from user_profile group by university order by avg_question_cnt ASC

2023-09-22

0 133

题解 | #浙江大学用户题目回答情况#

select qp.device_id,qp.question_id,qp.result from question_practice_detail as qp inner join user_profile as up where qp.device_id = up.device_id and ...

2023-09-18

0 156

题解 |输出和3306端口建立连接总的各个状态的数目#

#!/bin/bash cat nowcoder.txt| grep 3306| \ awk '{ ips[$5]++; states[$6]++; total_links++; } END { print "TOTAL_IP", length(...

2023-09-02

0 164

题解 | #netstat练习3-输出每个IP的连接数#

#!/bin/bash cat nowcoder.txt| grep tcp| awk '{print $5}'| awk -F':' '{print $1}'| sort| uniq -c| sort -nr| awk '{print $2" "$1}'

2023-09-02

1 178