Aufgabe 1/15
SQL Editor
Ergebnis
🔧 Query-Bauanleitung (Schritt für Schritt)
Musterlösung:
SELECT cols FROM table WHERE cond ORDER BY col LIMIT n
JOIN: INNER/LEFT/RIGHT JOIN table ON t1.col = t2.col
GROUP BY col HAVING agg_func(col) > val
Subquery: SELECT ... WHERE col IN (SELECT ...)
INSERT INTO table (cols) VALUES (vals)
UPDATE table SET col=val WHERE cond
DELETE FROM table WHERE cond