select marke , avg(PREIS) as d_preis
from ARTIKEL
         (select avg(PREIS)
    from ARTIKEL) as p
group by marke
having d_preis  > p
order by avg(PREIS) ;