Facebook
From Emerald Owl, 1 Year ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 116
  1. SELECT billing_address,
  2.        billing_city,
  3. FROM invoice
  4. WHERE (CAST(invoice_date AS date) AND invoice_date > '2009-08-31')
  5.   AND (CAST(invoice_date AS date) AND invoice_date < '2009-10-01')
  6.   AND (NOT billing_country = 'USA'
  7.        AND NOT billing_country = 'Brazil')
  8.   AND total >2;