is there a way to get an aggregate like SUM yet of a number field? Im thinking about how to best implement a rating system, where each rating can be between 1 and 5

Maybe you can be more specific on the backend you're implementing this on. But have a look at this, it might help... https://stackoverflow.com/questions/2324446/how-to-build-a-basic-and-simple-5-star-rating-system

oh im just using prisma cloud and graphql-yoga