Average Transaction by Country | Dataford Interview Questions

Write a query to find the average transaction amount for each country on WePay, excluding transactions marked as fraud.

Use the provided WePay country and transaction data. Include countries with no eligible transactions, returning a NULL average for those countries.

Output

countries

Column	Type	Description
country_idPK	INT	Unique country identifier
country_name	VARCHAR(100)	Country name displayed in reports

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
country_id	INT	Country associated with the transaction
amount	DECIMAL(12,2)	Transaction amount
is_fraud	BOOLEAN	Whether the transaction was marked as fraud

Your question is Average Transaction by Country. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Write a query to find the average transaction amount for each country on WePay, excluding transactions marked as fraud.

Use the provided WePay country and transaction data. Include countries with no eligible transactions, returning a NULL average for those countries.

countries

Column	Type	Description
country_idPK	INT	Unique country identifier
country_name	VARCHAR(100)	Country name displayed in reports

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
country_id	INT	Country associated with the transaction
amount	DECIMAL(12,2)	Transaction amount
is_fraud	BOOLEAN	Whether the transaction was marked as fraud

Your question is Average Transaction by Country. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.