Day-of-Week Revenue Pivot

WITH per_invoice AS (
  SELECT BillingCountry,
         EXTRACT(DOW FROM InvoiceDate)::int AS dow,
         Total
  FROM Invoice
)
SELECT BillingCountry,
       ROUND(SUM(CASE WHEN dow = 0 THEN Total ELSE 0 END), 2) AS Sun,
       ROUND(SUM(CASE WHEN dow = 1 THEN Total ELSE 0 END), 2) AS Mon,
       ROUND(SUM(CASE WHEN dow = 2 THEN Total ELSE 0 END), 2) AS Tue,
       ROUND(SUM(CASE WHEN dow = 3 THEN Total ELSE 0 END), 2) AS Wed,
       ROUND(SUM(CASE WHEN dow = 4 THEN Total ELSE 0 END), 2) AS Thu,
       ROUND(SUM(CASE WHEN dow = 5 THEN Total ELSE 0 END), 2) AS Fri,
       ROUND(SUM(CASE WHEN dow = 6 THEN Total ELSE 0 END), 2) AS Sat,
       ROUND(SUM(Total), 2) AS TotalRevenue,
       ROUND(SUM(CASE WHEN dow IN (0, 6) THEN Total ELSE 0 END) * 100.0 / NULLIF(SUM(Total), 0), 2) AS WeekendShare
FROM per_invoice
GROUP BY BillingCountry
HAVING SUM(Total) >= 25
ORDER BY WeekendShare DESC, TotalRevenue DESC;