44.Merchant - 客户的地区分布报告

dimestore想推出一个区域营销活动，管理想要一个按照每个区域的客户数量按邮政编码分组的报告．

SELECT COUNT(customer) AS customerCount, state
FROM customer 
GROUP BY state
ORDER BY customerCount DESC

结果：

{
  "results": [
    {
      "customerCount": 27,
      "state": "NC"
    },
    {
      "customerCount": 24,
      "state": "FL"
    },
    {
      "customerCount": 23,
      "state": "VA"
    },
    {
      "customerCount": 23,
      "state": "IA"
    },
    {
      "customerCount": 21,
      "state": "TN"
    },
    {
      "customerCount": 21,
      "state": "OK"
    },
    {
      "customerCount": 20,
      "state": "KS"
    },
    {
      "customerCount": 19,
      "state": "AR"
    },
    {
      "customerCount": 19,
      "state": "IN"
    },
    {
      "customerCount": 19,
      "state": "WA"
    },
    {
      "customerCount": 19,
      "state": "CA"
    },
    {
      "customerCount": 19,
      "state": "HI"
    },
    {
      "customerCount": 19,
      "state": "GU"
    },
    {
      "customerCount": 19,
      "state": "WV"
    },
    {
      "customerCount": 19,
      "state": "ND"
    },
    {
      "customerCount": 19,
      "state": "CO"
    },
    {
      "customerCount": 18,
      "state": "MI"
    },
    {
      "customerCount": 18,
      "state": "TX"
    },
    {
      "customerCount": 18,
      "state": "MO"
    },
    {
      "customerCount": 18,
      "state": "UT"
    },
    {
      "customerCount": 18,
      "state": "IL"
    },
    {
      "customerCount": 18,
      "state": "NY"
    },
    {
      "customerCount": 17,
      "state": "AZ"
    },
    {
      "customerCount": 17,
      "state": "PA"
    },
    {
      "customerCount": 17,
      "state": "NE"
    },
    {
      "customerCount": 17,
      "state": "MP"
    },
    {
      "customerCount": 17,
      "state": "MA"
    },
    {
      "customerCount": 17,
      "state": "NV"
    },
    {
      "customerCount": 16,
      "state": "AA"
    },
    {
      "customerCount": 16,
      "state": "VT"
    },
    {
      "customerCount": 16,
      "state": "MS"
    },
    {
      "customerCount": 16,
      "state": "WI"
    },
    {
      "customerCount": 16,
      "state": "DE"
    },
    {
      "customerCount": 15,
      "state": "AE"
    },
    {
      "customerCount": 15,
      "state": "FM"
    },
    {
      "customerCount": 15,
      "state": "MT"
    },
    {
      "customerCount": 15,
      "state": "MH"
    },
    {
      "customerCount": 15,
      "state": "NH"
    },
    {
      "customerCount": 15,
      "state": "RI"
    },
    {
      "customerCount": 15,
      "state": "NJ"
    },
    {
      "customerCount": 15,
      "state": "WY"
    },
    {
      "customerCount": 15,
      "state": "SC"
    },
    {
      "customerCount": 15,
      "state": "LA"
    },
    {
      "customerCount": 14,
      "state": "KY"
    },
    {
      "customerCount": 14,
      "state": "CT"
    },
    {
      "customerCount": 14,
      "state": "ME"
    },
    {
      "customerCount": 14,
      "state": "NM"
    },
    {
      "customerCount": 14,
      "state": "OR"
    },
    {
      "customerCount": 13,
      "state": "VI"
    },
    {
      "customerCount": 13,
      "state": "DC"
    },
    {
      "customerCount": 13,
      "state": "ID"
    },
    {
      "customerCount": 13,
      "state": "AS"
    },
    {
      "customerCount": 12,
      "state": "AP"
    },
    {
      "customerCount": 12,
      "state": "AK"
    },
    {
      "customerCount": 12,
      "state": "GA"
    },
    {
      "customerCount": 12,
      "state": "OH"
    },
    {
      "customerCount": 12,
      "state": "PR"
    },
    {
      "customerCount": 11,
      "state": "MN"
    },
    {
      "customerCount": 11,
      "state": "AL"
    },
    {
      "customerCount": 9,
      "state": "MD"
    },
    {
      "customerCount": 9,
      "state": "SD"
    },
    {
      "customerCount": 8,
      "state": "PW"
    }
  ]
}