select r.bueronr as Raumnummer, g.macadresse as MAC_Adresse, m.abteilung as Abteilung, l.liefernr as Liefernummer, l.typ as Typ
from mitarbeiter as m, geraet as g, lieferung as l, raum as r
where g.liefernr=l.liefernr and g.personalnr=m.personalnr
and m.raumid=r.raumid
and r.gebaeude="A" and l.stueckzahl < 10;