- SELECT i.billing_country,
- MIN(i.total) AS min_total,
- MAX(i.total) AS max_total,
- AVG(i.total) AS avg_total
- FROM invoice AS i
- WHERE i.invoice_id IN (SELECT invoice_id
- FROM (SELECT invoice_id,
- COUNT(quantity),
- AVG(unit_price)
- FROM invoice_line
- GROUP BY invoice_id) AS crop
- WHERE count > 5
- AND i.total > avg)
- GROUP BY i.billing_country
- ORDER BY avg_total DESC;