/* Formatted on 2002/12/13 09:21 (RevealNet Formatter v4.4.0) */
SELECT COUNT (a.yhbh) AS yhsm
FROM jb.jb_yhk a, qx.qx_dt_yhjbsjk b
WHERE a.csdm = 14
AND a.yhbh = b.yhbh
AND a.qxdm IN (24,32,40,48,56,64,72,80,158,159,160,161,
168
)
AND a.pzrq <= LAST_DAY (TO_DATE ('2003-1-1', 'YYYY-MM-DD'))
AND a.jyzt = 1
AND b.jylx = 1
AND b.yhjb IN (2)
AND a.jjlx IN (10, 11, 12, 13, 14, 15, 16, 17, 18)