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")
