SELECT CategoryRef, AVG(SUM(NumShares+NumFacebook)) AS AverageSharesFROM NewsGROUP BY CategoryRefORDER BY AVG(NumShares) DESC;