如何创建这样的查询
https://docs.microsoft.com/en-us/sql/relational-databases/json/format-query-results-as-json-with-for-json-sql-server?view=sql-server-2017
但在mysql中，它在方括号中显示错误，如果我使用'
查询：

SELECT
  max(cpm) as [cpm.1],
  min(cpm) as [cpm.2]
FROM
  b.s;

和

SELECT
  max(cpm) as 'cpm.1',
  min(cpm) as 'cpm.2'
FROM
  b.s;

第一个错误，第二个结果是

[
  {
    "cpm.1" : 10.91,
    "cpm.2" : 10.91
  }
]

结果应该是

[
  {
    "cpm" :
    {
      "1" : 10.91,
      "2" : 10.91
    }
  }
]