文章测试

SELECT p.prod_name, i.item_cnt    FROM (SELECT  prod_id, COUNT(*) item_cnt               FROM sales               GROUP BY prod_id) i RIGHT OUTER JOIN  products p    ON   i.prod_id  = p.prod_id;

SELECT p.prod_name, i.item_cnt    FROM (SELECT  prod_id, COUNT(*) item_cnt               FROM sales               GROUP BY prod_id) i RIGHT OUTER JOIN  products p    ON   i.prod_id  = p.prod_id;