- SELECT billing_city
- FROM invoice
- WHERE billing_city IN (SELECT billing_city
- FROM invoice
- WHERE EXTRACT(YEAR FROM cast(invoice_date AS date)) = 2009
- GROUP BY billing_city
- HAVING total > AVG(total))
- GROUP BY billing_city;
Title | Name | Language | When |
---|---|---|---|
Re: Re: Re: Re: Re: Untitled | Gentle Tapir | text | 3 Months ago. |