SHOW:
|
|
- or go back to the newest paste.
| 1 | - | SELECT * |
| 1 | + | SELECT CAST(invoice_date AS date), |
| 2 | customer_id, | |
| 3 | - | WHERE EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) IN (9); |
| 3 | + | total |
| 4 | FROM invoice | |
| 5 | WHERE EXTRACT(MONTH FROM CAST(invoice_date AS timestamp)) = 9 | |
| 6 | AND customer_id in (11, 13, 44, 36, 48, 52, 54, 56) |
