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
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
INDIVIDUAL_ID | GENDER | AGE |
---|---|---|
3 | M | 21 |
2 | F | 51 |
1 | M | 41 |
4 | M | 41 |
INDIVIDUAL_ID | DOLLAR_VALUE_US | QUANTITY | TRANSACTION_NUMBER | TXN_DATE | BRAND_ORG_CODE | IS_MERCH | CURRENCY_CODE | LINE_ITEM_AMT_TYPE_CD | TRANTYPE |
---|---|---|---|---|---|---|---|---|---|
1 | 10 | 30 | 12345 | 01-FEB-19 | BRAND | 1 | USD | S | POS |
1 | 10 | 40 | 345 | 10-FEB-19 | BRAND | 1 | USD | S | POS |
1 | 10 | 50 | 678 | 15-FEB-19 | BRAND | 1 | USD | S | ONLINE |
1 | 10 | 70 | 975 | 28-FEB-19 | BRAND | 1 | USD | S | ONLINE |
2 | 11 | 80 | 910 | 11-FEB-19 | BRAND | 1 | USD | S | POS |
2 | 11 | 90 | 323 | 12-FEB-19 | BRAND | 1 | USD | S | ONLINE |
3 | 11 | 62 | 855 | 12-FEB-19 | BRAND | 1 | USD | S | POS |
4 | 11 | 30 | 866 | 12-MAY-18 | BRAND | 1 | USD | S | ONLINE |
4 | 11 | 30 | 869 | 12-FEB-19 | BRAND | 1 | USD | S | POS |
INDIVIDUAL_ID | DOLLAR_VALUE_US | TXN_DATE | QUANTITY | TRANSACTION_NUMBER | GENDER | AGE | MIN_TXN_DATE | TRANTYPE |
---|---|---|---|---|---|---|---|---|
1 | 10 | 01-FEB-19 | 30 | 12345 | M | 41 | 01-FEB-19 | POS |
1 | 10 | 10-FEB-19 | 40 | 345 | M | 41 | 01-FEB-19 | POS |
1 | 10 | 15-FEB-19 | 50 | 678 | M | 41 | 01-FEB-19 | ONLINE |
1 | 10 | 28-FEB-19 | 70 | 975 | M | 41 | 01-FEB-19 | ONLINE |
2 | 11 | 11-FEB-19 | 80 | 910 | F | 51 | 11-FEB-19 | POS |
2 | 11 | 12-FEB-19 | 90 | 323 | F | 51 | 11-FEB-19 | ONLINE |
3 | 11 | 12-FEB-19 | 62 | 855 | M | 21 | 12-FEB-19 | POS |
4 | 11 | 12-MAY-18 | 30 | 866 | M | 41 | 12-MAY-18 | ONLINE |
4 | 11 | 12-FEB-19 | 30 | 869 | M | 41 | 12-MAY-18 | POS |
INDIVIDUAL_ID | DOLLAR_VALUE_US | TXN_DATE | QUANTITY | TRANSACTION_NUMBER | GENDER | AGE | MIN_TXN_DATE | TRANTYPE |
---|---|---|---|---|---|---|---|---|
1 | 10 | 10-FEB-19 | 40 | 345 | M | 41 | 01-FEB-19 | POS |
1 | 10 | 01-FEB-19 | 30 | 12345 | M | 41 | 01-FEB-19 | POS |
2 | 11 | 11-FEB-19 | 80 | 910 | F | 51 | 11-FEB-19 | POS |
3 | 11 | 12-FEB-19 | 62 | 855 | M | 21 | 12-FEB-19 | POS |
4 | 11 | 12-FEB-19 | 30 | 869 | M | 41 | 12-FEB-19 | POS |
INDIVIDUAL_ID | DOLLAR_VALUE_US | TXN_DATE | QUANTITY | TRANSACTION_NUMBER | GENDER | AGE | MIN_TXN_DATE | TRANTYPE |
---|---|---|---|---|---|---|---|---|
1 | 10 | 28-FEB-19 | 70 | 975 | M | 41 | 15-FEB-19 | ONLINE |
1 | 10 | 15-FEB-19 | 50 | 678 | M | 41 | 15-FEB-19 | ONLINE |
2 | 11 | 12-FEB-19 | 90 | 323 | F | 51 | 12-FEB-19 | ONLINE |
4 | 11 | 12-MAY-18 | 30 | 866 | M | 41 | 12-MAY-18 | ONLINE |
TYPE_OF_CUSTOMER | COUNT_OF_CUSTOMERS | COUNT_OF_TRANSACTIONS | SUM_OF_QUANTITY |
---|---|---|---|
New Customers | 3 | 3 | 172 |
Returning Customers | 1 | 1 | 40 |
TYPE_OF_CUSTOMER | COUNT_OF_CUSTOMERS | COUNT_OF_TRANSACTIONS | SUM_OF_QUANTITY |
---|---|---|---|
New Customers | 2 | 2 | 140 |
TYPE_OF_CUSTOMER | COUNT_OF_CUSTOMERS | COUNT_OF_TRANSACTIONS | SUM_OF_QUANTITY |
---|---|---|---|
New Customers | 2 | 3 | 232 |
Returning Customers | 2 | 3 | 120 |
GENDER | AGEGROUP | INDIV | TXN_COUNT | SPEND | QTY |
---|---|---|---|---|---|
F | 46-52 | 1 | 2 | 22 | 170 |
M | 18-24 | 1 | 1 | 11 | 62 |
GENDER | AGEGROUP | INDIV | TXN_COUNT | SPEND | QTY |
---|---|---|---|---|---|
M | 40-46 | 2 | 3 | 31 | 120 |
TYPE_OF_CUSTOMER | COUNT_OF_CUSTOMERS | COUNT_OF_TRANSACTIONS | SUM_OF_QUANTITY |
---|---|---|---|
New Customers | 2 | 3 | 232 |
Returning Customers | 2 | 3 | 120 |
TYPE_OF_CUSTOMER | COUNT_OF_CUSTOMERS | COUNT_OF_TRANSACTIONS | SUM_OF_QUANTITY |
---|---|---|---|
New Customers | 1 | 2 | 170 |
Returning Customers | 2 | 3 | 120 |
TYPE_OF_CUSTOMER | COUNT_OF_CUSTOMERS | COUNT_OF_TRANSACTIONS | SUM_OF_QUANTITY |
---|---|---|---|
New Customers | 2 | 3 | 232 |
Returning Customers | 2 | 3 | 120 |