Re: Re: Re: Re: Untitled

From Perl Elephant, 3 Months ago, written in Plain Text, viewed 67 times. This paste is a reply to Re: Re: Re: Untitled from Idiotic Coyote - view diff
URL Embed
Download Paste or View Raw
  1. SELECT billing_city
  2. FROM invoice
  3. WHERE billing_city IN (SELECT billing_city
  4.                        FROM invoice
  5.                        WHERE EXTRACT(YEAR FROM cast(invoice_date AS date)) = 2009
  6.                        GROUP BY billing_city
  7.                        HAVING total > AVG(total))
  8. GROUP BY billing_city;

Replies to Re: Re: Re: Re: Untitled rss

Title Name Language When
Re: Re: Re: Re: Re: Untitled Gentle Tapir text 3 Months ago.

Reply to "Re: Re: Re: Re: Untitled"

Here you can reply to the paste above