SHOW:
|
|
- or go back to the newest paste.
| 1 | - | SELECT COUNT(*) - COUNT(fax) |
| 1 | + | --Посчитайте среднюю стоимость заказов, оформленных в понедельник. |
| 2 | - | FROM client; |
| 2 | + | |
| 3 | SELECT AVG(total) | |
| 4 | FROM invoice | |
| 5 | WHERE CAST(invoice_date AS timestamp) = DATE_TRUNC('week', CAST(invoice_date AS timestamp)); |
