牛客958631006号

分类

题解(14)

/ 注册

全部文章（共6篇）

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

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

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

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

Mysql

2022-05-08

2 302

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

cat nowcoder.txt | awk -F "" 'BEGIN{}{{A[NR]=0}{for(i=1;i<=NF;i++){if(=1&̲&" class="katex-error">i>=1&&i<=5){A[NR]++;B[20]++}...

Mysql

2022-05-05

0 299

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

select gender, university,count(gender),round(avg(active_days_within_30),1),round(avg(question_cnt),1) from user_profile group by gender,university

Mysql

2022-05-05

0 209