Turing_Yang

分类

/ 注册

全部文章（共16篇）

题解 | #用户名规范化#

select device_id, CONCAT(UPPER(SUBSTRING(substring_index(blog_url,'/',-1), 1, 1)), LOWER(SUBSTRING(substring_index(blog_url,'/',-1), 2))) as user_nam...

2023-10-11

0 127

题解 | #用户昵称超长的用户#

select device_id, nick_name, char_length(nick_name) as nick_len from user_submit where char_length(nick_name)>4 order by device_id desc 搞清楚lengt...

2023-10-11

0 120

题解 | #用户每月最后一周的练题数#

select device_id, date_format (event_date, '%Y年%m月') as ym, count(question_id) as cnt from question_practice_detail where datedif...

2023-10-11

0 115

题解 | #每月各旬有多少人练题#

select ( concat( concat(substr(event_date,1,4),'年'), concat(substr(event_date,6,2),'月'), ( case when day(event_date)<=9 then '上旬' when...

2023-10-11

0 81

题解 | #各年级学生的平均绩点#

select case when graduate_year = '2022' then '大四' when graduate_year = '2023' then '大三' when graduate_year = '2024' then '大二' when graduate_year = '20...

2023-10-11

0 137

题解 | #所有用户对高难度题目的刷题数#

select t1.device_id, convert(sum(if(difficult_level='hard',1,0)),signed) as question_cnt from user_profile t1 left join question_practice_detail t2 ...

2023-10-11

0 128

题解 | #学生数不大于2的学校的学生情况#

select university, count(distinct id) as cnt, group_concat(distinct device_id order by id separator ';') as device_list from user_profile group by un...

2023-10-11

0 104

题解 | #每个学校有哪些年龄的学生#

select university, group_concat(distinct age order by age) as age_concat from user_profile group by university 这个题目主要考察，分组之后连接的函数group_concat()。

2023-10-11

0 96

题解 | #筛选某店铺最有价值用户中消费最多前5名#

import sys for line in sys.stdin: a = line.split() print(int(a[0]) + int(a[1])) import pandas as pd df = pd.read_csv("sales.csv")...

2023-10-11

0 137

题解 | #某店铺用户消费特征评分#

import sys for line in sys.stdin: a = line.split() print(int(a[0]) + int(a[1])) import pandas as pd df = pd.read_csv('sales.csv') df['R_Qu...

2023-10-11

0 139