Ontology.inrae.fr

SELECT COUNT(?T_min)
WHERE {
    SELECT  ?jour ?mois (MIN(?value) AS ?T_min)  
    WHERE { GRAPH inrae_graph:2019 {
        ?obs a sosa:Observation.
        ?obs sosa:observedProperty inrae_property:air_temperature.
        ?obs sosa:resultTime ?timeStamp.
        ?obs sosa:hasResult ?res.
        ?res qudt:numericValue ?value.
        BIND (DAY(?timeStamp+"PT6H"^^xsd:duration) AS ?jour).
        BIND (MONTH(?timeStamp+"PT6H"^^xsd:duration) AS ?mois).
        FILTER ( YEAR(?timeStamp)=2019 )
    }}
    GROUP BY ?mois ?jour
    HAVING ( ?T_min < 0 )
    ORDER BY ?mois ?jour
}