daily temperature in sheffield (weather mast)

PREFIX opensheff: <uri://opensheffield.org/properties#>

SELECT
    SUBSTR(?d, 9, 2) AS ?DAY
    SUBSTR(?d, 6, 2) AS ?MONTH
    SUBSTR(?d, 1, 4) AS ?YEAR
    AVG(?temp) AS ?day_temp
    COUNT(1) AS ?measurements
WHERE {
    ?m opensheff:sensor <uri://opensheffield.org/datagrid/sensors/Weather_Mast/Weather_Mast.ic> ;
       opensheff:rawValue ?temp ;
       <http://purl.oclc.org/NET/ssnx/ssn#endTime> ?time .
    BIND( SUBSTR(?time, 1, 10) AS ?d ) .
}
GROUP BY ?d
ORDER BY ASC(?d)