SHOW:
|
|
- or go back to the newest paste.
| 1 | - | SELECT billing_address, |
| 1 | + | SELECT * |
| 2 | - | billing_city |
| 2 | + | |
| 3 | WHERE total < 5 | |
| 4 | - | WHERE total > 2 |
| 4 | + | AND (CAST(invoice_date AS DATE) BETWEEN '2009-03-04' AND '2012-02-09') |
| 5 | - | AND (CAST(invoice_date AS date) BETWEEN '2009-09-01' AND '2009-10-01') |
| 5 | + | AND billing_country NOT IN ('Canada',
|
| 6 | - | AND NOT (billing_country = 'USA' |
| 6 | + | 'Brazil', |
| 7 | - | OR billing_country = 'Brazil'); |
| 7 | + | 'Finland'); |