Ultimate access to all questions.
You are tasked with converting temperature readings from Celsius to Fahrenheit in an IoT dataset. Each device has 5 readings stored in an array. Complete the SQL query by selecting the appropriate function to apply the conversion to each element in the array.
Schema: deviceId INT, deviceTemp ARRAY
SELECT deviceId, __(deviceTempC, i -> (i * 9/5) + 32) as deviceTempF FROM sensors