how can I create a route in Strapi that returns the sum of all numbers in my collection?

Questions and Answers
1
System Information
  • Strapi Version:
  • Operating System:
  • Database:
  • Node Version:
  • NPM Version:
  • Yarn Version:

how can I create a route in Strapi that returns the sum of all numbers in my collection?

I have a collection called phones and a field in phones called quantities…

when I do a get request to phones/sum I want the numbers in the fields quantities to be added as one and returned as a single number