1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| CREATE OR REPLACE VIEW `V_191018095110ug_valeur` AS
SELECT
indice,
ROUND(MIN(`191018095110ug_valeur`.`valeur`), 2) AS min,
ROUND(AVG(`191018095110ug_valeur`.`valeur`), 2) AS avg,
ROUND(MAX(`191018095110ug_valeur`.`valeur`), 2) AS max,
ROUND(SUM(`191018095110ug_valeur`.`valeur`), 2) AS sum,
ROUND(MIN(`191018095110ug_valeur`.`pvaleur`),2) AS minP,
ROUND(AVG(`191018095110ug_valeur`.`pvaleur`),2) AS avgP,
ROUND(MAX(`191018095110ug_valeur`.`pvaleur`),2) AS maxP,
ROUND(SUM(`191018095110ug_valeur`.`pvaleur`),2) AS sumP
FROM
191018095110ug_valeur
WHERE
indice IS NOT NULL
ORDER BY indice; |
Partager