Sha256: 8509106524701e060f722442b27764ce9bc85079ccbfb420b1cb10bf9247308d

Contents?: true

Size: 508 Bytes

Versions: 2

Compression:

Stored size: 508 Bytes

Contents

<result>
  {
    let $end_dates := doc("items.xml")//item_tuple/end_date
    for $m in distinct-values(for $e in $end_dates 
                              return month-from-date($e))
    let $item := doc("items.xml")
        //item_tuple[year-from-date(end_date) = 1999 
                     and month-from-date(end_date) = $m]
    order by $m
    return
        <monthly_result>
            <month>{ $m }</month>
            <item_count>{ count($item) }</item_count>
        </monthly_result>
  }
</result>

Version data entries

2 entries across 2 versions & 1 rubygems

Version Path
magic_xml-0.1.1 xquery_use_cases/rdb/q9.xquery
magic_xml-0.1.0 xquery_use_cases/rdb/q9.xquery