Untitled

From Smelly Mosquito, 1 Year ago, written in Plain Text, viewed 239 times.
URL http://codebin.org/view/a906e560 Embed
Download Paste or View Raw
  1.  
  2. SELECT c.last_name
  3. FROM client AS c
  4. LEFT OUTER JOIN invoice AS i ON c.customer_id = i.customer_id
  5. WHERE c.customer_id IN (SELECT i.customer_id
  6.                      FROM invoice
  7.                      WHERE CAST (invoice_date AS date) BETWEEN '2013-01-01' AND '2013-01-31'
  8.                                     AND EXTRACT (YEAR FROM CAST (invoice_date AS date)) = 2013
  9.                          AND CAST (invoice_date AS date) BETWEEN '2013-02-01' AND '2013-12-31' )    

Reply to "Untitled"

Here you can reply to the paste above