Query for Superbowl Offer Volume by Region

gistfile1.txt

SELECT
  service_regions.name region_name,
  SUM(cart_items.quantity) total_quantity,
  offers.name offer_name
FROM
  orders
INNER JOIN cart_items ON cart_items.order_id = orders.id
INNER JOIN offers ON offers.id = cart_items.offer_id
INNER JOIN service_regions ON service_regions.id = orders.service_region_id
WHERE 
  DATE(orders.delivery_window_starts_at - INTERVAL '7' HOUR) = '2015-02-01'
GROUP BY 
  service_regions.name, 
  offers.name
ORDER BY region_name ASC, total_quantity DESC;

this must be run against the production follower db