Création des vues températures par heure et par jour

CREATE VIEW ventilation_cellules_H AS
SELECT * FROM ventilation_cellules T1,
(SELECT Time_Stamp AS tmpTime
FROM ventilation_cellules
GROUP BY DATE(Time_Stamp), HOUR(Time_Stamp)) T2
WHERE T1.Time_Stamp = T2.tmpTime;

CREATE VIEW ventilation_cellules_j AS
SELECT * FROM ventilation_cellules T1,
(SELECT MIN(Time_Stamp) AS tmpTime
FROM ventilation_cellules
GROUP BY DATE(Time_Stamp)) T2
WHERE T1.Time_Stamp = T2.tmpTime;