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.

Table Schema

• deviceId INT
• deviceTemp ARRAY<DOUBLE>
• dateTimeCollected TIMESTAMP

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

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