SQL-Abfragen

SELECT month (l_datum), COUNT(*) FROM leie, kunden WHERE kunden.k_nr = leihe.k_nr
GROUP BY month (l_datum)
ORDER BY 2 desc

SELECT f_titel, COUNT(*) anzahl
FROM filme, leihe
WHERE filme.f_nr = leihe.f_nr
GROUP BY filme.f_nr
HAVING anzahl < 5
ORDER BY 2

SELECT sum (f_preis * l_tage) , k_nachname
FROM kunden, leihe, filme
WHERE leihe.f_nr = filme.f_nr and kunden.k_nr = leihe.k_nr
GROUP BY l_datum 2
 

select sum(f_preis*l_datum), f_kategorie
FROM leihe, filme
WHERE leihe.f_nr = filme.f_nr
GROUP BY 2

SELECT sum(f_preis * l_tage), month(l_datum)
FROM leihe, filme
WHERE leihe.f_nr = filme.f_nr
AND year (l_datum) = 2003
GROUP BY 2

SELECT (f_preis * l_tage), k_nachname
FROM leihe, filme, kunden
WHERE leihe.f_nr = filme.f_nr
AND kunden.k_nr = leihe.k_nr
GROUP BY 2
ORDER BY 1 desc

SELECT sum(f_preis * l_tage) umsatz, k_nachname
FROM kunden, leihe, filme
WHERE leihe.f_nr = filme.f_nr
AND kunden.k_nr = leihe.k_nr
GROUP BY 2
HAVING umsatz < > 300
ORDER BY 1 desc