| drop dataverse gby-using-orderby-desc if exists; |
| create dataverse gby-using-orderby-desc; |
| use dataverse gby-using-orderby-desc; |
| create type AddressType as closed { |
| create type CustomerType as closed { |
| create nodegroup group1 if not exists on nc1, nc2; |
| create dataset Customers(CustomerType) |
| primary key cid on group1; |
| write output to nc1:"rttest/gby-using-orderby-desc.adm"; |
| for $c in dataset('Customers') |
| group by $name := $c.name decor $age := $c.age with $c |
| order by $name desc, $age asc |
| return { "name": $name, "age": $age } |