Query for Superbowl Order Size by Region

gistfile1.txt

SELECT
  service_regions.name region_name,
  COUNT(orders.id) order_count,
  AVG(orders.price) avg_price,
  STDDEV_POP(orders.price) std_price,
  MIN(orders.price) min_price,
  MAX(orders.price) max_price
FROM orders
INNER JOIN service_regions ON service_regions.id = orders.service_region_id
WHERE 
  DATE(orders.ext_delivery_window_starts_at_local) = '2015-02-01'
GROUP BY 
  service_regions.name
ORDER BY region_name ASC, avg_price DESC;