All Notes on BCA

SELECT p.prod_no, SUM(s.qty_Order) as "Total Order"
FROM sales_order_t5 s
FULL OUTER JOIN product p
ON p.prod_no = s.product_no
GROUP BY prod_no;

PROD_N Total Order
------ -----------
0001             4
0006
0005
0002             2
0004            10
0003             2