Another user is trying to evaluate transactions by country. Lists of transactions are a start, but they really want to see some totals for comparison. In the transactions table, you use bipp to add an amount column to aggregate the totals using the invoice_qnty and unit_price columns.
Select your columns:
bipp generates the SQL:
SELECT t000.country AS _0, sum(t000.invoice_qnty*t000.unit_price) AS _1 FROM `online_retail`.`transactions` AS t000 GROUP BY 1
Fetch the data:
Select a chart to make it easier for your user to see the relationships:
IN THIS PAGE