LISTING A: Making Parents Appear After Their Children

WITH SET MySet AS '{CA,CA.Children,[OR],[OR].Children}'
SELECT
  Generate(ORDER(MySet,([Sales Count],[1998]),DESC) AS
  MySetIterator,{MySetIterator.Item(MySetIterator.Count-
  Rank(MySetIterator.Current.Item(0),MySetIterator))}) ON 0
FROM sales
WHERE [Sales Count]