34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT COUNT(a.uid) 人数
FROM 用户表 a,
(select uid , substring(substring(content,CHARINDEX('wuli',content)+5, LEN(content)),1,
CHARINDEX('|',substring(content,CHARINDEX('wuli',content)+5, LEN(content)))-1) score FROM 成绩表) b
WHERE a.uid = b.uid
AND a.[地区] = '市中区' AND a.[学校]='一中' AND a.[年级]='1' AND a.[班级]='1'
AND b.score >=70 AND b.score <=80