The following SQL query gives me every instance of all coupons used in a certain time period. What I would like to do and cannot seem to accomplish is have another report where the number of times a promotion is used is displayed beside the promotion, ie

PROMOTIONA 2,345
PROMOTIONB 344
PROMOTIONC 1,298

Thanks

SELECT

min(p.promotion_id) as promo_code,
o.order_id as order_id
FROM
coupon c,
promotion p,
price_adjust pa,
amtinfo_adj aa,
ship_group sg,
g_order o,
order_price op,
user u,
t_order t,
item i,
item_price ip,
amount_info ai
WHERE
p.promotion_id = pa.pricing_model
and aa.adjustments = pa.adjustment_id
and sg.price_info = aa.amount_info_id
and o.order_id = sg.order_ref
and t.order_id = o.order_id
and u.id = o.profile_id
and i.order_ref = o.order_id
and op.amount_info_id = o.price_info
and ai.amount_info_id = i.price_info
and ip.amount_info_id = i.price_info
and o.submitted_date >= trunc(sysdate -1)
GROUP BY
o.order_id
ORDER BY
min(p.promotion_id),
min(trunc(o.submitted_date))