SELECT SUM(Antal) AS [Antal artiklar], CONVERT(DECIMAL(8,0), ROUND(SUM(Antal*Pris), 0)) AS [Totalt lagervärde], CONVERT(DECIMAL(8,0), ROUND(MAX(Pris), 0)) AS [Maxvärde], CONVERT(DECIMAL(8,0), ROUND(MIN(Pris), 0)) AS [Minvärde], CONVERT(DECIMAL(8,0), ROUND(AVG(Pris), 0)) AS [Medelvärde] FROM Artikel
WHERE Antal > (SELECT (AVG(Antal)) FROM Artikel);