{
  "plan": {
    "#operator": "Sequence",
    "~children": [
      {
        "#operator": "Sequence",
        "~children": [
          {
            "#operator": "IndexScan3",
            "as": "c2",
            "covers": [
              "cover (((`c2`.`address`).`zip`))",
              "cover ((`c2`.`month`))",
              "cover ((`c2`.`order_list`))",
              "cover ((`c2`.`sale_price`))",
              "cover ((meta(`c2`).`id`))"
            ],
            "index": "sl2",
            "index_id": "7859cd31524b7bd6",
            "index_projection": {
              "entry_keys": [
                0,
                2
              ],
              "primary_key": true
            },
            "keyspace": "bucket-1",
            "namespace": "default",
            "spans": [
              {
                "exact": true,
                "range": [
                  {
                    "high": "\"00040\"",
                    "inclusion": 3,
                    "low": "\"00040\""
                  }
                ]
              }
            ],
            "using": "gsi"
          },
          {
            "#operator": "Join",
            "as": "o2",
            "keyspace": "bucket-1",
            "namespace": "default",
            "on_keys": "(`c2`.`order_list`)"
          },
          {
            "#operator": "Parallel",
            "~child": {
              "#operator": "Sequence",
              "~children": [
                {
                  "#operator": "Filter",
                  "condition": "((cover (((`c2`.`address`).`zip`)) = \"00040\") and ((`o2`.`month`) = \"October\"))"
                },
                {
                  "#operator": "InitialGroup",
                  "aggregates": [
                    "sum((`o2`.`sale_price`))"
                  ],
                  "group_keys": [
                    "(`o2`.`month`)",
                    "cover (((`c2`.`address`).`zip`))"
                  ]
                }
              ]
            }
          },
          {
            "#operator": "IntermediateGroup",
            "aggregates": [
              "sum((`o2`.`sale_price`))"
            ],
            "group_keys": [
              "(`o2`.`month`)",
              "cover (((`c2`.`address`).`zip`))"
            ]
          },
          {
            "#operator": "FinalGroup",
            "aggregates": [
              "sum((`o2`.`sale_price`))"
            ],
            "group_keys": [
              "(`o2`.`month`)",
              "cover (((`c2`.`address`).`zip`))"
            ]
          },
          {
            "#operator": "Parallel",
            "~child": {
              "#operator": "Sequence",
              "~children": [
                {
                  "#operator": "InitialProject",
                  "result_terms": [
                    {
                      "expr": "(`o2`.`month`)"
                    },
                    {
                      "expr": "cover (((`c2`.`address`).`zip`))"
                    },
                    {
                      "expr": "sum((`o2`.`sale_price`))"
                    }
                  ]
                }
              ]
            }
          }
        ]
      },
      {
        "#operator": "Order",
        "sort_terms": [
          {
            "expr": "sum((`o2`.`sale_price`))"
          }
        ]
      },
      {
        "#operator": "FinalProject"
      }
    ]
  },
  "text": "SELECT o2.month, c2.address.zip, SUM(o2.sale_price) \nFROM `bucket-1` c2 INNER JOIN `bucket-1` o2 ON (META(o2).id IN c2.order_list) \nWHERE c2.address.zip = \"00040\" AND o2.month = \"October\"\nGROUP BY o2.month, c2.address.zip ORDER BY SUM(o2.sale_price)"
}