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