vxquery-benchmark/src/main/resources/noaa-ghcn-daily/other_systems/mrql/q07_count_1980.mrql

/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements. See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License. You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
count(
    select (toInt(text(rtmax.value))-toInt(text(rtmin.value)))
    from rtmax in source(xml, args[0], {"data"}),
        dtmax in rtmax.date,
        rtmin in source(xml, args[2], {"data"}),
        dtmin in rtmin.date
    where text(rtmax.date) = text(rtmin.date)
        and text(rtmax.station) = text(rtmin.station)
        and text(rtmax.dataType) = "TMAX"
        and toInt(substring(text(dtmax), 0, 4)) > 1980
        and text(rtmin.dataType) = "TMIN"
        and toInt(substring(text(dtmin), 0, 4)) > 1980
)
;