datemydata

SQL generato

SELECT
  s.type AS veranstaltungstyp,
  SUM(CASE WHEN EXTRACT(YEAR FROM s.start_date) = 2024 THEN b.amount_chf ELSE 0 END) AS umsatz_2024_chf,
  SUM(CASE WHEN EXTRACT(YEAR FROM s.start_date) = 2025 THEN b.amount_chf ELSE 0 END) AS umsatz_2025_chf
FROM bookings b
JOIN seminars s ON b.rel_seminar_pk = s.pk
WHERE b.status <> 'cancelled'
  AND s.start_date >= DATE '2024-01-01'
  AND s.start_date < DATE '2026-01-01'
GROUP BY s.type
ORDER BY umsatz_2025_chf DESC;