Analyse de l'utilisation des focales sur un ensemble de photos

Hello,

I found a solution to answer to my question.
First I tried the plugin List-View but there are some bugs on macos.
Then I installed a SQL DB tool : DB Browser for SQLite.
Open a .lrcat file from a backup and analysed all tables.
I understood a part of the functionalities from each table and I wrote two SQL requests.

The 1st provides the list of used focal length and the number of occurrences for each one. After export to a .csv file, it is easy to open it in a spreadsheet to build a chart.
The 2nd provides the list of used focal length per camera and lens. After export to a .csv file, it is easy to open it in a spreadsheet to build a pivot table.

Both requests have been made for Nikon camera.
It is easy to change that or to improve requests to take into account some other cameras.

SQL request #1
SELECT m.focalLength, count(m.focalLength) as numberOcc
FROM "main"."AgHarvestedExifMetadata" m
JOIN "main"."AgInternedExifCameraModel" c
ON m.cameraModelRef = c.id_local
JOIN "main"."AgInternedExifLens" l
ON m.lensRef = l.id_local
WHERE (c.value LIKE '%NIKON Z 6_2%' ESCAPE '\' OR c.value LIKE '%NIKON Z 7_2%' ESCAPE '\' OR c.value LIKE '%NIKON Z6_3%' ESCAPE '\' OR c.value LIKE '%NIKON D700%' ESCAPE '\')
GROUP BY m.focalLength
ORDER BY m.focalLength ASC;

SQL request #2
SELECT m.focalLength, l.value as lens, c.value as camera
FROM "main"."AgHarvestedExifMetadata" m
JOIN "main"."AgInternedExifCameraModel" c
ON m.cameraModelRef = c.id_local
JOIN "main"."AgInternedExifLens" l
ON m.lensRef = l.id_local
WHERE (c.value LIKE '%NIKON%' ESCAPE '\')
ORDER BY m.focalLength ASC;

Gilles