Documentation DataKanu Warehouse

-- Chiffre d'affaires par mois
SELECT date_trunc(order_date, 'month') AS mois,
       sum(amount) AS ca
FROM analytics.orders
WHERE status = 'delivered'
GROUP BY mois
ORDER BY mois DESC;