Query:
Output:
SELECT sales_order_no, COUNT(product_no) as Total_Product FROM sales_order_t5 GROUP BY sales_order_no;
SALES_ TOTAL_PRODUCT ------ ------------- o00001 1 o00002 1 o00003 1 o00004 1