Floats owner per years

https://argo.ogs.it/medargo/stat_float_quant_country.php?dal=01/01/2015&al=31/12/2020&oceano=5 Numero di float per year per country SELECT EXTRACT (YEAR from d.deployment_time) AS anno,d.country_www, Count(d.id_float) AS ConteggioDiid_float FROM tbl_sensori_web AS sensweb RIGHT JOIN (((tbl_telemetry AS t RIGHT JOIN (tbl_type AS y RIGHT JOIN tbl_float as d ON y.id_type = d.id_type) ON t.id_telemetry = d.id_telemetry) LEFT JOIN tbl_positioning_system AS pos ON d.id_positioning_system = pos.id_positioning_system) LEFT JOIN tbl_float_sensori_web AS sensfloatweb ON d.id_float = sensfloatweb.id_float) ON sensweb.id_sensori_web = sensfloatweb.id_sensori_web GROUP BY anno, d.country_www ORDER BY anno,d.country_www;