Untitled

From Ungracious Goose, 4 Months ago, written in Plain Text, viewed 55 times.
URL http://codebin.org/view/eaca0a36 Embed
Download Paste or View Raw
  1. SELECT SUM(total),
  2.        COUNT(customer_id),
  3.        SUM(total)/COUNT(total)
  4. FROM invoice
  5. WHERE billing_country = 'USA'
  6. GROUP BY DISTINCT customer_id;

Reply to "Untitled"

Here you can reply to the paste above