[FEATURE]: Display Count on Category options

[jamesqquick]

Describe the solution you'd like
As a user, I would like to be able to see how many deals there are by category. I would like to see this count inside of the pill of the category option.

Describe the benefits of your solution
This could further incentivize users to look into specific categories.

Additional Notes

• this will require adding a new db query in the src/lib/queries.ts file
• could use prisma groupBy function with _count

Groupby - https://www.prisma.io/docs/orm/prisma-client/queries/aggregation-grouping-summarizing#groupby-and-filtering
Count - https://www.prisma.io/docs/orm/prisma-client/queries/aggregation-grouping-summarizing#count-records

Example (not tested)

  const dealsCountByCategory = await prisma.deals.groupBy({
    by: ['category'],
    _count: {
      _all: true,
    },
  });