insert order (prod_id, prod_cnt)
select prod_id, count(*)
from product
group by prod_id