http://argo.ogs.it/stat/drifter_stat7.php
quanti strumenti di un tipo di telemetria per anno
Query usata: SELECT Count(d.id_drifter) AS quanti, coalesce(t.tipo_det, 'Unknown') AS tipo_det, EXTRACT(YEAR FROM d.deployment_time) AS anno FROM (((tbl_drifter AS d LEFT JOIN tbl_type AS y ON d.id_type = y.id_type) LEFT JOIN tbl_positioning_system AS pos ON d.id_positioning_system = pos.id_positioning_system) LEFT JOIN tbl_telemetry AS t ON d.id_telemetry = t.id_telemetry) WHERE d.daelaborare=TRUE AND (id_oceano = 5) GROUP BY d.daelaborare, coalesce(t.tipo_det, 'Unknown'), EXTRACT(YEAR FROM d.deployment_time) ORDER BY anno;