Untitled

From Harmless Owl, 3 Months ago, written in Plain Text, viewed 50 times.

URL http://codebin.org/view/d04b0d12 Embed

Download Paste or View Raw

SELECT SUM(total), COUNT(DISTINCT(customer_id)), SUM(total)/COUNT(DISTINCT(customer_id))
FROM invoice
WHERE billing_country = 'USA'
GROUP BY customer_id;

Reply to "Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?