SHOW:
|
|
- or go back to the newest paste.
| 1 | - | SELECT name |
| 1 | + | SELECT customer_id, |
| 2 | - | FROM track |
| 2 | + | invoice_date, |
| 3 | - | WHERE (milliseconds > 300000 |
| 3 | + | total, |
| 4 | - | AND composer LIKE '%Bono%' |
| 4 | + | DATE_TRUNC('month', CAST(invoice_date AS timestamp)),
|
| 5 | - | AND genre_id IN (7, 8, 9, 10)) |
| 5 | + | EXTRACT(WEEK FROM CAST(invoice_date AS timestamp)) |
| 6 | - | OR bytes > 1000000000; |
| 6 | + | FROM invoice |
| 7 | WHERE(customer_id BETWEEN 20 AND 50); |
