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;