SQL: von Zeilendarstellung in Spaltendarstellung

[omata]

Kleine Korrektur...

SQL-Code:

SELECT Name,
       SUM(CASE WHEN abwesenheitsgrund = 'Urlaub'   THEN 1 ELSE 0 END) AS Urlaub,
       SUM(CASE WHEN abwesenheitsgrund = 'Krank'    THEN 1 ELSE 0 END) AS Krank,
       SUM(CASE WHEN abwesenheitsgrund = 'Seminar'  THEN 1 ELSE 0 END) AS Seminar,
       SUM(CASE WHEN abwesenheitsgrund = 'Feiertag' THEN 1 ELSE 0 END) AS Feiertag
FROM tabelle
GROUP BY name