Fetch the most common device make/models for photos from the EXIF data

SELECT make, model, COUNT(1) AS count
FROM photos
WHERE make IS NOT NULL
GROUP BY make, model
ORDER BY COUNT(1) DESC;