1:
2:
3:
4:

SELECT FTEsKAT.KAT, Sum(FTEs.AStunden/35) AS Wert
FROM FTEsKAT, FTEs
WHERE (FTEs.KAT_ID=FTEsKAT.KAT_ID)
GROUP BY KAT;

1:
2:
3:
4:

SELECT Quartal.Q_ID, count(Prozess.P_ID) AS Anzahl
FROM Quartal, Prozess
WHERE NOT  (Prozess.P_End < Quartal.Q_Start OR Prozess.P_Start > Quartal.Q_End)
GROUP BY Quartal.Q_ID;

1:
2:

SELECT (blub_enddatum – blub_startdatum) AS Dauer_Tage
FROM blub;

1:
2:
3:
4:
5:
6:

SELECT Q_ID, COUNT(*) AS [Anzahl Prozesse pro Quartal]
FROM Quartal
WHERE Q_Start <= (SELECT P_Start FROM Prozess) AND Q_End >= (SELECT P_End FROM Prozess)
OR Q_Start > (SELECT P_Start FROM Prozess) AND Q_Start < (SELECT P_End FROM Prozess)
OR Q_Start < (SELECT P_Start FROM Prozess) AND Q_End < (SELECT P_End FROM Prozess)
GROUP BY Q_ID;

1:

mysql_query ( 'TRUNCATE newtbl' );