You are tasked with identifying how often a temperature sensor exceeds a threshold temperature of 100.00 for each device. Each row in the dataset contains 5 readings collected every 5 minutes. Complete the SQL query by filling in the blanks with the appropriate functions.

Schema: deviceId INT, deviceTemp ARRAY, dateTimeCollected TIMESTAMP

SELECT deviceId, __ (__ (__(deviceTemp], i -> i > 100.00))) FROM devices GROUP BY deviceId