sql---两个查询

1.
Sql代码  
SELECT D.WGMC, D.JDMC, D.HS, COUNT(6) ZS  
FROM  
(SELECT C.WGMC WGMC,C.WGBM WGBM,C.JDMC JDMC,C.HS HS  
FROM (SELECT COUNT(2) HS,WG.WGMC,WG.WGBM,JD.JDMC   
FROM T_SHSJGL_GH H, T_SHSJGL_WG WG,T_SHSJGL_SQ SQ,T_SHSJGL_JD JD WHERE   
H.GRID_ID = WG.ID  AND WG.SQID = SQ.ID AND SQ.JDID = JD.ID  GROUP BY WG.WGMC,WG.WGBM,JD.JDMC ) C WHERE C.HS<70) D,T_SHSJGL_GZ GZ  
WHERE GZ.SZWG=D.WGBM  
GROUP BY D.WGMC, D.JDMC, D.HS  
ORDER BY D.HS ASC  

2.
Sql代码  
SELECT C.WGMC WGMC,C.JDMC JDMC,C.HS HS,COUNT(C.ZBM) ZS  
FROM (SELECT COUNT(2) HS,WG.WGMC WGMC,GZ.ZBM ZBM,JD.JDMC  JDMC  
FROM T_SHSJGL_GH H, T_SHSJGL_GZ GZ,T_SHSJGL_WG WG,T_SHSJGL_SQ SQ,T_SHSJGL_JD JD  
WHERE H.GRID_ID = WG.ID AND GZ.SZWG=WG.WGBM AND WG.SQID = SQ.ID AND SQ.JDID = JD.ID  GROUP BY WG.WGMC,GZ.ZBM,JD.JDMC ) C   
WHERE C.HS<70  
GROUP BY C.WGMC,C.JDMC,C.HS  
ORDER BY C.HS ASC