Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT (*) FROM Teilnehmer
- SELECT COUNT (DISTINCT Ort) AS Schulorte FRom Ort
- SELECT SUM ( Dauer) AS Gesamtdauer_in_Freiburg FROM Kurs K, Ort O
- WHERE (K.Ort_Nr = O.Ort_Nr) AND (O.Ort = 'Freiburg')
- SELECT AVG (Dauer) AS Durchschnittsdauer FROM Kurs
- SELECT MIN (Dauer) AS Minimale_Kursdauer FROM Kurs
- SELECT Voraussetzungen, SUM (Dauer) AS Gesamtdauer FROM Kurs
- GROUP BY Voraussetzungen ORDER BY Sum (Dauer) DESC
- SELECT Ort, COUNT (Ort) AS Veranstaltungen FROM Ort
- GROUP BY Ort ORDER BY COUNT(Ort) DESC, Ort ASC
- SELECT Ort, SUM (Dauer) AS Gesamtdauer FROM Kurs, Ort
- WHERE Kurs.Ort_Nr = Ort.Ort_Nr GROUP BY Ort HAVING SUM (Dauer) >=10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement