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'); |