oracle多表连接查询，统计求和，分组

SELECT
	c.typeName siteName,
	NVL (SUM(o.recommCount), 0) recommCount,
	NVL (SUM(o.acceptCount), 0) acceptCount
FROM
	w1 o
RIGHT JOIN w2 n ON o.info_id = n. ID AND n.PUBYEAR='2019'
RIGHT JOIN w3 c ON c. ID = n.pubSiteId 
WHERE
	c. ID IS NOT NULL
 AND c.parentId='0'
 AND c.siteFlag=0
GROUP BY
	c.typeName
ORDER BY RECOMMCOUNT DESC

时间紧迫，后面再做总结归纳