By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
INDIVIDUAL_ID | DOLLAR_VALUE_US | QUANTITY | TRANSACTION_NUMBER | TXN_DATE | BRAND_ORG_CODE | IS_MERCH | CURRENCY_CODE | LINE_ITEM_AMT_TYPE_CD | SHIPPING_TOTAL | COUNTRY | QUARTER_DATE |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 10 | 30 | 12345 | 01-FEB-19 | BRAND | 1 | USD | S | 10 | USA | QT1 |
1 | 10 | 40 | 12345 | 10-FEB-19 | BRAND | 1 | USD | S | 10 | USA | QT1 |
1 | 10 | 50 | 12345 | 15-FEB-19 | BRAND | 1 | USD | S | 10 | USA | QT1 |
1 | 10 | 70 | 975 | 28-FEB-19 | BRAND | 1 | USD | S | 20 | ROU | QT1 |
2 | 11 | 80 | 975 | 11-FEB-19 | BRAND | 1 | USD | S | 20 | AFR | QT2 |
2 | 11 | 90 | 323 | 12-FEB-19 | BRAND | 1 | USD | S | 15 | IND | QT2 |
3 | 11 | 62 | 855 | 12-FEB-19 | BRAND | 1 | USD | S | 25 | USA | QT1 |
TRANSACTION_NUMBER | SUM(DOLLAR_VALUE_US) | SUM(QUANTITY) | SUM(SHIPPING_TOTAL) |
---|---|---|---|
12345 | 30 | 120 | 30 |
975 | 21 | 150 | 40 |
323 | 11 | 90 | 15 |
855 | 11 | 62 | 25 |
QUARTER_DATE | COUNTRY | SUM(DOLLAR_VALUE_US) | SUM(QUANTITY) | SUM(SHIPPING_TOTAL) |
---|---|---|---|---|
QT1 | USA | 41 | 182 | 55 |
QT1 | ROU | 10 | 70 | 20 |
QT2 | AFR | 11 | 80 | 20 |
QT2 | IND | 11 | 90 | 15 |