Task #3

From Kristina, 10 Months ago, written in Plain Text, viewed 98 times.
URL http://codebin.org/view/8b519fea Embed
Download Paste or View Raw
  1. SELECT i.billing_country,
  2.        MIN(i.total) AS min_total,
  3.        MAX(i.total) AS max_total,
  4.        AVG(i.total) AS avg_total
  5. FROM invoice AS i
  6. WHERE i.invoice_id IN (SELECT invoice_id
  7.                        FROM (SELECT invoice_id,
  8.                                     COUNT(quantity),
  9.                                     AVG(unit_price)
  10.                              FROM invoice_line
  11.                              GROUP BY invoice_id) AS crop
  12.                        WHERE count > 5
  13.                          AND i.total > avg)
  14. GROUP BY i.billing_country
  15. ORDER BY avg_total DESC;

Reply to "Task #3"

Here you can reply to the paste above