Customer Transaction Table – CUSTOMER_TXNS
Column Name
Description
Type
Account_id
Account identifier
Integer
Txn_timestamp
Time of transaction (UTC)
Timestamp
Product_id
The id of the product purchased
Integer
Txn_Amt
The revenue amount of the transaction
Float
Txn_Qty
The number of items purchased
Integer
NOTE: Customer Transaction table has multiplerecords per account_id.
Customer Master Table – CUSTOMER_MSTR
Column Name
Description
Type
Account_id
Account identifier
Integer
Country
Country Code
Character(3)
Address
Address of the customer
Character(64)
Registerd_Dt
Date the account id was first used
Date
Tier
Account Tier
Integer
NOTE: Customer Master table has one record peraccount_id.
Q-Write a query to show the distribution of customers by thenumber of products they have purchased.
Expert Answer
An answer will be send to you shortly. . . . .