stream analytics query for raspi

raspisensor.sql

SELECT
    System.Timestamp as Time,
    DeviceId,
    CAST(AVG(frompis.Temp) AS float) AS Temp,
    CAST(AVG(frompis.Pressure) AS float) AS Pressure,
    CAST(AVG(frompis.Hum) AS float) AS Hum,
    CAST(AVG(frompis.HiLux) AS float) AS HiLux,
    CAST(AVG(frompis.LowLux) AS float) AS LowLux    
INTO
    powerbi
FROM
    raspisensors TIMESTAMP BY Date
GROUP BY
    DeviceId,
    TumblingWindow(second, 30)