User contributions for GRUH

10 December 2024

• 12:0412:04, 10 December 2024 diff hist +3‎ HTL Aggregatfunktionen world ‎ →‎Bevölkerung current
• 12:0412:04, 10 December 2024 diff hist +2‎ HTL Aggregatfunktionen world ‎ →‎Fläche
• 12:0312:03, 10 December 2024 diff hist −184‎ HTL Aggregatfunktionen world ‎No edit summary
• 12:0012:00, 10 December 2024 diff hist +191‎ HTL Aggregatfunktionen world ‎No edit summary
• 11:4811:48, 10 December 2024 diff hist +195‎ HTL Aggregatfunktionen world ‎ →‎Einfache Aggregatfunktionen auf der World Tabelle
• 11:4311:43, 10 December 2024 diff hist +2,493‎ N HTL Aggregatfunktionen world ‎ Created page with "== Einfache Aggregatfunktionen auf der World Tabelle == <div class='qu'> Berechne die Gesamtbevölkerung aller Länder in der Tabelle. <source lang='sql' class='def'> </source> <source lang='sql' class='ans'> SELECT SUM(population) AS Gesamtbevölkerung FROM world; </source> </div> <div class='qu'> Finde die durchschnittliche Fläche der Länder in der Tabelle. <source lang='sql' class='def'> </source> <source lang='sql' class='ans'> SELECT AVG(area) AS Durchschni..."

9 December 2024

• 15:2815:28, 9 December 2024 diff hist +657‎ HTL Basics ‎ →‎Introducing the world table of countries current
• 15:1615:16, 9 December 2024 diff hist +217‎ HTL Basics ‎No edit summary
• 15:1315:13, 9 December 2024 diff hist −2‎ HTLWienWest ‎No edit summary current
• 15:1215:12, 9 December 2024 diff hist +76‎ HTLWienWest ‎ →‎Einführung SQL HTL Wien West
• 15:1015:10, 9 December 2024 diff hist −12‎ HTL Basics ‎No edit summary
• 15:0815:08, 9 December 2024 diff hist +29‎ HTL Basics ‎No edit summary
• 14:5814:58, 9 December 2024 diff hist +664‎ HTL Basics ‎No edit summary
• 14:5714:57, 9 December 2024 diff hist +42‎ HTLWienWest ‎ →‎Einführung SQL HTL Wien West
• 14:5514:55, 9 December 2024 diff hist +27‎ HTLWienWest ‎ →‎Einführung SQL HTL Wien West
• 14:5414:54, 9 December 2024 diff hist −175‎ HTL ‎No edit summary current
• 14:5314:53, 9 December 2024 diff hist +24‎ N HTL/Basics ‎ GRUH moved page HTL/Basics to HTL Basics current Tag: New redirect
• 14:5314:53, 9 December 2024 diff hist 0‎ m HTL Basics ‎ GRUH moved page HTL/Basics to HTL Basics
• 14:4914:49, 9 December 2024 diff hist +458‎ N HTL Basics ‎ Created page with "==Introducing the <code>world</code> table of countries== <div class='qu'> The example uses a WHERE clause to show the population of 'France'. Note that strings should be in 'single quotes'; <p class='imper'>Modify it to show the population of Germany</p> <source lang='sql' class='def'> SELECT population FROM world WHERE name = 'France' </source> <source lang='sql' class='ans'> SELECT population FROM world WHERE name = 'Germany' </source> </div>"
• 14:4714:47, 9 December 2024 diff hist +204‎ HTL ‎No edit summary
• 14:4614:46, 9 December 2024 diff hist −17‎ HTL ‎No edit summary

9 May 2022

• 18:4918:49, 9 May 2022 diff hist +4‎ N HTLWienWest/deleteme ‎ Created page with "TEST" current
• 09:0809:08, 9 May 2022 diff hist +20‎ HTLWienWest/SMUE 2022-05-09 5ABIF ‎ →‎Abfragen zur Tabelle world current
• 09:0609:06, 9 May 2022 diff hist +20‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Abfragen zur Tabelle world current
• 09:0309:03, 9 May 2022 diff hist +23‎ HTLWienWest/Group By Having 01 ‎ →‎Abfragen zur Tabelle world current
• 08:4508:45, 9 May 2022 diff hist 0‎ HTLWienWest/SMUE 2022-05-09 5ABIF ‎ →‎Abfragen zur Tabelle world
• 08:4508:45, 9 May 2022 diff hist 0‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Abfragen zur Tabelle world
• 08:4408:44, 9 May 2022 diff hist 0‎ HTLWienWest/Group By Having 01 ‎ →‎Abfragen zur Tabelle world
• 08:0508:05, 9 May 2022 diff hist +94‎ HTLWienWest/Group By Having 01 ‎ →‎Einleitung
• 08:0208:02, 9 May 2022 diff hist +2‎ HTLWienWest/Group By Having 01 ‎ →‎Einleitung
• 08:0208:02, 9 May 2022 diff hist +2‎ HTLWienWest/Group By Having 01 ‎ →‎Einleitung
• 08:0208:02, 9 May 2022 diff hist +67‎ HTLWienWest/Group By Having 01 ‎ →‎Einleitung
• 07:5307:53, 9 May 2022 diff hist +4,415‎ N HTLWienWest/Group By Having 01 ‎ Created page with "__TOC__ == Einleitung == Schalten Sie in den Einstellungen (Zahnrad oben rechts) auf die SQL Engine : MySQL um! == Die Tabelle world == <div class="ref_section"> <pre class=output> +-------------------+---------+-------+----------+------------+----------------+ |name |continent|area |population|gdp |capital | +-------------------+---------+-------+----------+------------+----------------+ |Afghanistan |Asia | 652230| 255001..."

8 May 2022

• 18:3618:36, 8 May 2022 diff hist +6,435‎ N HTLWienWest/SMUE 2022-05-09 5ABIF ‎ Created page with "__TOC__ == Einleitung == Schalten Sie in den Einstellungen (Zahnrad oben rechts) auf die SQL Engine : MySQL um! <br> Geben Sie zu jeder Frage das erforderliche SQL Statement ein. Als Hilfestellung sehen Sie unter der jeweiligen Frage das zu erwartende Ergebnis.<br> <div class='qu'> Setzen Sie im unten angegeben SQL Statement Ihren Namen ein und führen Sie es aus.<br> '''Achten Sie darauf, dass bei der Abgabe als PDF hier ihr Name steht. Abgaben ohne Namen werden MIT N..."
• 18:2018:20, 8 May 2022 diff hist +115‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Abgabe
• 18:1918:19, 8 May 2022 diff hist +5‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Einleitung
• 18:1918:19, 8 May 2022 diff hist +133‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Einleitung
• 18:1418:14, 8 May 2022 diff hist −64‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Abgabe
• 18:1118:11, 8 May 2022 diff hist +69‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Abgabe
• 18:0718:07, 8 May 2022 diff hist −9‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Abgabe
• 18:0518:05, 8 May 2022 diff hist −8‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Abgabe
• 17:5917:59, 8 May 2022 diff hist +366‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎No edit summary
• 17:4817:48, 8 May 2022 diff hist −1,085‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Die Tabelle world
• 17:4617:46, 8 May 2022 diff hist +1,140‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Die Tabelle world
• 17:4417:44, 8 May 2022 diff hist +47‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Die Tabelle world
• 17:4117:41, 8 May 2022 diff hist +10‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Die Tabelle world
• 17:3617:36, 8 May 2022 diff hist 0‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Einleitung
• 17:2817:28, 8 May 2022 diff hist +92‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Einleitung
• 17:2517:25, 8 May 2022 diff hist +4‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Einleitung
• 17:2517:25, 8 May 2022 diff hist −4‎ HTLWienWest/SMUE 2022-05-09 2ACIF ‎ →‎Einleitung