SELECT A.KCMC, A.JCMC, A.ZZ, A.CBS, A.BB, A.PRICE, C.XH, C.XM, C.XZB, RS.RS
FROM JXRWB A,
XSXKB B,
XSJBXXB C,
(SELECT B.XKKH, A.XZB, COUNT(A.XZB) RS
FROM XSJBXXB A, XSXKB B
WHERE A.XH = B.XH
GROUP BY B.XKKH, A.XZB) RS
WHERE A.XN = '2016-2017'
AND A.XQ = '2'
AND A.BKMC IS NOT NULL
AND A.XKKH = B.XKKH
AND B.XH = C.XH
AND RS.XKKH = A.XKKH
ORDER BY A.JCMC, C.XZB, C.XH
大学英语分层查询人数代码
Ctrl+shirt+f4
¥29.8
¥9.9
¥59.8