Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- masql:nuetzliches [2022/01/20 13:59] – Thomas Große
+++ masql:nuetzliches [2022/01/20 14:00] (aktuell) – Thomas Große
@@ Zeile 18: / Zeile 18: @@
 <code sql>
 SELECT COUNT(*) AS "Gesamt",
-	SUM(IF((DATEDIFF(CURRENT_DATE, t.geb_datum)/365 DIV 1) BETWEEN 1 AND 19,1,0)) AS "Bis 19 Jahre",
+    SUM(IF((DATEDIFF(CURRENT_DATE, t.geb_datum)/365 DIV 1) BETWEEN 1 AND 19,1,0)) AS "Bis 19 Jahre",
-	SUM(IF((DATEDIFF(CURRENT_DATE, t.geb_datum)/365 DIV 1) BETWEEN 20 AND 29,1,0)) AS "Von 20 bis 29 Jahre",
+    SUM(IF((DATEDIFF(CURRENT_DATE, t.geb_datum)/365 DIV 1) BETWEEN 20 AND 29,1,0)) AS "Von 20 bis 29 Jahre",
-	SUM(IF((DATEDIFF(CURRENT_DATE, t.geb_datum)/365 DIV 1) BETWEEN 30 AND 49,1,0)) AS "Von 30 bis 49 Jahre",
+    SUM(IF((DATEDIFF(CURRENT_DATE, t.geb_datum)/365 DIV 1) BETWEEN 30 AND 49,1,0)) AS "Von 30 bis 49 Jahre",
-	SUM(IF((DATEDIFF(CURRENT_DATE, t.geb_datum)/365 DIV 1) >49,1,0)) AS "Ab 50 Jahre",
+    SUM(IF((DATEDIFF(CURRENT_DATE, t.geb_datum)/365 DIV 1) >49,1,0)) AS "Ab 50 Jahre",
-FROM tabelle s;
+FROM tabelle t;
 </code>