MySQL：搜索所有相机与相机型号并统计数量

[wanghao]

SELECT
  JSON_EXTRACT(file.metadata, "$.Make", "$.Model") as camera,
  COUNT(JSON_EXTRACT(file.metadata, "$.Make", "$.Model")) as count
FROM
  file
WHERE
  JSON_EXTRACT(file.metadata, "$.Make", '$.Model')
GROUP BY
  JSON_EXTRACT(file.metadata, "$.Make", "$.Model")