select
min(score) as min_score_over_avg
from
(
select
score,
avg(score) over (
partition by
tag
) as avg_score
from
exam_record a
join examination_info b on a.exam_id = b.exam_id
where
tag = 'SQL'
) a
where
score >= avg_score

京公网安备 11010502036488号