学习生1

分类

/ 注册

全部文章（共175篇）

题解 | #统计每天总刷题数#

select date as days,sum(pass_count) as passCnt from questions_pass_record_detail group by date;

2024-11-20

0 49

题解 | #计算单次平均刷题数#

select avg(pass_count) as avgCnt from questions_pass_record_detail;

2024-11-20

0 49

题解 | #找出sql类题目的单次最大刷题数#

select max(pass_count) as maxCnt from questions_pass_record_detail where question_type = 'sql';

2024-11-20

0 133

题解 | #计算刷题总人数#

select count(distinct user_id) as cnt from questions_pass_record_detail;

2024-11-20

0 50

题解 | #计算总刷题数,并将所选列名改为总刷题数#

select sum(pass_count) as '总刷题数' from questions_pass_record_detail; sum用来求和

2024-11-20

0 74

题解 | #查询城市为北京的职位投递记录#

select *from deliver_record_detail where job_city like '北京%';

2024-11-20

0 60

题解 | #查询薪资信息不为空的职位投递记录#

select * from deliver_record_detail where min_salary is not NULL or max_salary is not NULL;

2024-11-20

0 102

题解 | #查询在pc上投递的所有投递记录#

select *from deliver_record_detail where device='pc';

2024-11-20

0 62

题解 | #查询表总行数#

select count(user_id) as cnt from deliver_record; 选择一列的长度为行数

2024-11-20

0 70

题解 | #查询所有投递用户user_id并去重#

select distinct user_id from deliver_record;

2024-11-20

0 75