| Sort | |
| collation: [SUMSALES ASC, SS_CUSTOMER_SK ASC] | |
| fetch: 100 | |
| est: (rows=100) | |
| ColocatedHashAggregate | |
| fieldNames: [SS_CUSTOMER_SK, SUMSALES] | |
| group: [SS_CUSTOMER_SK] | |
| aggregation: [SUM(ACT_SALES)] | |
| est: (rows=191835) | |
| Project | |
| fieldNames: [SS_CUSTOMER_SK, ACT_SALES] | |
| projection: [SS_CUSTOMER_SK, CASE(IS NOT NULL(SR_RETURN_QUANTITY), *(-(SS_QUANTITY, SR_RETURN_QUANTITY), SS_SALES_PRICE), *(SS_QUANTITY, SS_SALES_PRICE))] | |
| est: (rows=959175) | |
| HashJoin | |
| predicate: =(SR_REASON_SK, R_REASON_SK) | |
| type: inner | |
| est: (rows=959175) | |
| HashJoin | |
| predicate: AND(=(SR_ITEM_SK, SS_ITEM_SK), =(SR_TICKET_NUMBER, SS_TICKET_NUMBER)) | |
| type: left | |
| est: (rows=2880404) | |
| Exchange | |
| distribution: single | |
| est: (rows=2880404) | |
| TableScan | |
| table: PUBLIC.STORE_SALES | |
| fieldNames: [SS_ITEM_SK, SS_CUSTOMER_SK, SS_TICKET_NUMBER, SS_QUANTITY, SS_SALES_PRICE] | |
| est: (rows=2880404) | |
| Exchange | |
| distribution: single | |
| est: (rows=287514) | |
| TableScan | |
| table: PUBLIC.STORE_RETURNS | |
| fieldNames: [SR_ITEM_SK, SR_REASON_SK, SR_TICKET_NUMBER, SR_RETURN_QUANTITY] | |
| est: (rows=287514) | |
| Exchange | |
| distribution: single | |
| est: (rows=12) | |
| TableScan | |
| table: PUBLIC.REASON | |
| predicate: =(R_REASON_DESC, _UTF-8'reason 66') | |
| fieldNames: [R_REASON_SK, R_REASON_DESC] | |
| est: (rows=12) |