Design a Support Agent Rating System

Design an agent rating system that allows customers to rate support agents on a scale of 1–5, retrieve average ratings per agent, and view agents sorted by their average rating.