SUM(CASE WHEN monthname(sales_date) = 'January' THEN amount ELSE 0 END) as 'Jan-21', SUM(CASE WHEN monthname(sales_date) = 'February' THEN amount ELSE 0 END) as 'Feb ...
This repository is based on https://github.com/duckdb/extension-template, check it out if you want to build and ship your own DuckDB extension. This extension, pivot ...