Berechnung zwischen mehreren SQL-Statements

[omata]

SQL-Code:

SELECT datum, interval, SUM(typ2) + SUM(typ3) * SUM(typ14) AS ergebnis
FROM (SELECT datum, interval,
             CASE WHEN typ =  2 THEN wert ELSE 0 END typ2,
             CASE WHEN typ =  3 THEN wert ELSE 0 END typ3,
             CASE WHEN typ = 14 THEN wert ELSE 0 END typ14
      FROM element
      WHERE bereich in (2, 3, 4)) x
GROUP BY datum, interval