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 Embed
Download Paste or View Raw
  1. SELECT DATE_TRUNC('week', CAST( invoice_date AS timestamp),-- впишите поле с категориями
  2.        SUM(total),
  3.            COUNT(DISTINCT customer_id),
  4.            SUM(total)/COUNT(DISTINCT customer_id)
  5. FROM invoice
  6. WHERE billing_country = 'USA'
  7. group by DATE_TRUNC('week', CAST( invoice_date AS timestamp));-- сгруппируйте данные

Replies to Re: Re: Re: Untitled rss

Title Name Language When
Re: Re: Re: Re: Untitled Beefy Tamarin text 8 Months ago.

Reply to "Re: Re: Re: Untitled"

Here you can reply to the paste above