38.0 (2) 40.0 (6) 40.5 (1) 41.0 (4) 42.0 (11) 43.0 (4) 44.0 (2) 45.0 (5) 46.5 (1) 50.0 (1)
Barrique (3) Holzfass (34)
Select count(w.preis) from wein as w join weindetail as d on w.nummer=d.nummer left outer join auszeichnung as a on w.nummer=a.weinid and w.jahrgang=a.jahrgang where w.preis between 0 and 4.99 Select count(w.preis) from wein as w join weindetail as d on w.nummer=d.nummer left outer join auszeichnung as a on w.nummer=a.weinid and w.jahrgang=a.jahrgang where w.preis between 5 and 9.99 Select count(w.preis) from wein as w join weindetail as d on w.nummer=d.nummer left outer join auszeichnung as a on w.nummer=a.weinid and w.jahrgang=a.jahrgang where w.preis between 10 and 14.99 Select count(w.preis) from wein as w join weindetail as d on w.nummer=d.nummer left outer join auszeichnung as a on w.nummer=a.weinid and w.jahrgang=a.jahrgang where w.preis between 15 and 19.99 Preis 15.00-19.99 € (2) Select count(w.preis) from wein as w join weindetail as d on w.nummer=d.nummer left outer join auszeichnung as a on w.nummer=a.weinid and w.jahrgang=a.jahrgang where w.preis between 20 and 29.99 Preis 20.00-29.99 € (11) Select count(w.preis) from wein as w join weindetail as d on w.nummer=d.nummer left outer join auszeichnung as a on w.nummer=a.weinid and w.jahrgang=a.jahrgang where w.preis between 30 and 999.99 Preis > 30.00 € (24)