- SELECT DATE_TRUNC('week', CAST( invoice_date AS timestamp),-- впишите поле с категориями
- SUM(total),
- COUNT(DISTINCT customer_id),
- SUM(total)/COUNT(DISTINCT customer_id)
- FROM invoice
- WHERE billing_country = 'USA'
- group by DATE_TRUNC('week', CAST( invoice_date AS timestamp));-- сгруппируйте данные
Re: Re: Re: Untitled
From Tacky Pintail, 8 Months ago, written in Plain Text, viewed 193 times.
This paste is a reply to Re: Re: Untitled from Flying Matamata
- view diff
URL http://codebin.org/view/5b554efc
Embed
Download Paste or View Raw
— Expand Paste to full width of browser
