Untitled

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

Replies to Untitled rss

Title Name Language When
Re: Untitled Smelly Finch text 4 Months ago.

Reply to "Untitled"

Here you can reply to the paste above