Owen433

分类

/ 注册

全部文章（共65篇）

题解 | #试卷完成数同比2020年的增长率及排名变化#

with t3 as (select t2.tag, year(t1.start_time) as start_year, count(t1.submit_time) as exam_cnt, rank() over(par...

2023-10-20

0 224

题解 | #连续两次作答试卷的最大时间窗#

with t1 as( select uid, timestampdiff(day,date_format(lag(start_time) over(partition by uid order by start_time),'%Y%m%d'),date_format (start_...

2023-10-11

0 200

题解 | #每个6/7级用户活跃情况#

with user_info as (select uid from user_info where level in (6,7)), examination_info as (select exam_id from examination_info), union_tabl...

2023-10-10

0 306

题解 | #满足条件的用户的试卷完成数和题目练习数#

with temp_table as ( select distinct t1.uid from user_info t1, examination_info t2, exam_record t3 where ...

2023-10-09

0 328

题解 | #分别满足两个活动的人#

select * from (select t1.uid, 'activity1' as activity from exam_record t1 group by t1.uid having ...

2023-10-09

0 172

题解 | #每个题目和每份试卷被作答的人数和次数#

select tid, uv, pv from (select 1 as exam, t1.exam_id as tid, count(distinct t1.uid) as uv, count(t1....

2023-10-09

0 239

题解 | #作答试卷得分大于过80的人的用户等级分布#

select t1.level, count(t1.uid) as level_cnt from user_info t1, examination_info t2, exam_record t3 where t1.uid = t3.uid ...

2023-10-09

0 237

题解 | #试卷发布当天作答人数和平均分#

select t2.exam_id, count(distinct t3.uid) as uv, round(avg(t3.score),1) as avg_score from user_info t1, examination_info t2, ...

2023-10-09

0 231

题解 | #使用梯度下降对逻辑回归进行训练#

import pandas as pd import numpy as np dataSet = pd.read_csv('dataSet.csv',header = None) labels = pd.read_csv('labels.csv',header = None) def sigmo...

2023-10-07

3 431

题解 | #得分不小于平均分的最低分#

select min(t3.score) min_score_over_avg from (select t1.score, avg(t1.score) over(partition by t2.tag) avg_score from ...

2023-10-06

0 240