best-king-86949
11/16/2022, 4:25 PMbright-smartphone-11251
orders_by_month
query at all?
2. What browser are you using
3. Can you see any errors in the browser (in opening developer tools)
4. What version of node and npm do you have node -v
npm -v
?bright-smartphone-11251
best-king-86949
11/16/2022, 4:42 PMbright-smartphone-11251
```orders_by_month
select
substr(order_datetime,1,7) || "-01" as date,
count(*) as number_of_orders,
sum(sales) as sales_usd0k,
sum(sales)/count(*) as average_order_value_usd2
from orders
```
This should solve itbright-smartphone-11251
bright-smartphone-11251
best-king-86949
11/16/2022, 5:05 PM