SQL
SELECT CustomerId, SUM(Sales)
FROM "order-details"
WHERE State = "CO"
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10Last updated
Was this helpful?
SQL allows for a custom SQL expression to be executed against table(s) inside a Workflow. The supported syntax is PostgreSQL and is executed using DuckDB.
Example SQL expression
SELECT CustomerId, SUM(Sales)
FROM "order-details"
WHERE State = "CO"
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10Last updated
Was this helpful?
Was this helpful?