Seagul

Lesson 5 - Unique count and amount by transaction type

Dataset statusAdvanced SQL exercisesvv1

Exercise content

Using customer_transactions, return for each txn_type:

the unique count of customers
the total transacted amount

Hints

Hint 1

Each final row must represent a txn_type. So you need GROUP BY txn_type.
Hint 2

For customers, use COUNT(DISTINCT customer_id). For amounts, use SUM(txn_amount).

Not completed

Loading dataset...

Latest result

No result set available.