GitHub

PostGre SQL Example - FILTER and EXTRACT MONTH.sql

COUNT(*) FILTER (WHERE EXTRACT(MONTH FROM order_date) = 3) AS March_Orders, COUNT(*) FILTER (WHERE EXTRACT(MONTH FROM order_date) = 4) AS April_Orders ...