Group By & Aggregate REST to GraphQL API Integration

Views can be used to expose the results of a custom query as a virtual table.

Sometimes we might want to fetch some data derived by aggregating (avg, min, max, etc.) over a group of rows in a table.

This view will fetch the average article rating for each author across two tables.

ERD Diagram

Read more here: Source link