Re: Re: Re: Re: Re: Re: Untitled

From Obese Pheasant, 2 Months ago, written in Plain Text, viewed 71 times. This paste is a reply to Re: Re: Re: Re: Re: Untitled from Crippled Pintail - view diff

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

Download Paste or View Raw

SELECT EXTRACT(YEAR FROM CAST(invoice_date AS date)),
       MIN(total),
       MAX(total),
       SUM(total),
       COUNT(invoice_id),
       ROUND(SUM(total)/COUNT(DISTINCT customer_id))
FROM invoice
WHERE billing_country IN('USA',
                        'United Kingdom',
                        'Germany')
ORDER BY EXTRACT(YEAR FROM CAST(invoice_date AS date)) DESC;

Reply to "Re: Re: Re: Re: Re: Re: 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?