Promo codes being used in certain regions of the U.S.

promoCodesUsedInRegions.sql

SELECT
    oi.PromoID,
    pc.PromoDescription,
    ca.CustomerRegion,
    COUNT(*) as totalPromoUsed
FROM
    commons.orderItem oi
    join commons.customerActivity ca on ca.CustomerID = oi.CustomerID
    Join commons.promoCode pc on pc.PromoID = oi.PromoID
WHERE
    oi.PromoID != 'nil'
    and pc.PromoID = :promoid
Group by
    oi.PromoID,
    ca.CustomerRegion,
    pc.PromoDescription
Order By
    totalPromoUsed DESC
;