1SELECT `provider`, AVG(`rating`) AS `AvgRating`, COUNT(`provider`) AS `ReviewCount` FROM `reviews` WHERE 1 GROUP BY `provider`;