anchor.diff:  ----
   // output tuples with fields teamName, wins, losses, and winPercentages where a null value for wins or losses is translated to the value of 0
   select(
  -  search(collection1, fl="id,teamName_s,wins,losses", q="*:*", sort="id asc"),
  +  search(collection1, fl="id,teamName_s,wins,losses", q="*:*", qt="/export", sort="id asc"),
     teamName_s as teamName,
     wins,
     losses,
  
positive.code: [source,text]
  ----
  cartesianProduct(
    search(collection1, q='*:*', fl='fieldA, fieldB, fieldC', sort='fieldA ASC'),
    fieldB as newFieldB,
    productSort="fieldB DESC"
  )
  
  {
  
negative.code: ----
  sort(
    innerJoin(
      search(people, q="*:*", qt="/export", fl="id,name", sort="id asc"),
      search(pets, q="type:dog", qt="/export", fl="owner,petName", sort="owner asc"),
      on="id=owner"
    ),
    by="name asc, petName asc"
  