牛客958631006号

题解

/ 注册

全部文章 / 题解（共13篇）

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

select question_practice_detail.device_id,question_practice_detail.question_id ,question_practice_detail.result from question_practice_detail,user_p...

Mysql

2022-05-10

1 239

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

select university,round(avg(question_cnt),4) as avg_question_cnt from user_profile group by university order by avg_question_cnt order by 根据什么排序

Mysql

2022-05-10

0 203

题解 | #分组过滤练习题#

select university,round(avg(question_cnt),3) as avg_question_cnt,round(avg(answer_cnt),3) as avg_answer_cnt from user_profile group by university ...

Mysql

2022-05-10

0 252

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

awk -F ":" '/tcp/{print 2}'| awk '{print 2}'| sort | uniq -c | sort -rn | awk '{print 2,2,2,1}'

bash

2022-05-10

0 346

题解 | #nginx日志分析6-统计每分钟的请求数#

awk -F ":" 'BEGIN{OFS=":"}{print 2,2,2,3}' | sort | uniq -c | sort -rn | awk '{print 1,1,1,2}'

bash

2022-05-10

0 330

题解 | #nginx日志分析5-统计爬虫抓取404的次数#

awk '/<404>/{print 0}'|awk '/baidu/{print 0}' | wc -l

bash

2022-05-10

0 337

题解 | #处理文本#

cat nowcoder.txt | sort -t ":" -k 1,1 -sb | awk -F ":" '{if(1 != str){print "["1"]\n"2;str=2;str =2;str=1;}else {print $2}}'

bash

2022-05-09

2 366

题解 | #格式化输出#

awk -F "" ' BEGIN{ ORS=""; OFS=""; } { if(NF <= 3){print 0;} else { a=NF%3; for(i=0;i<=NF;i++) { if(i == a&&...

bash

2022-05-09

0 496

题解 | #域名进行计数排序处理#

awk -F "/" '{ print 3}' nowcoder.txt | sort | uniq -c | sort -nr | awk '{print 1,$2}'

bash

2022-05-08

0 252

题解 | #分组计算练习题#

awk -F "." '{ aa = 0; if( NF == 4 ) { aa = 1; for(i = 1;i <= NF;i++) { ...

Mysql

2022-05-08

2 302