Index: database/drizzle/queries/builds.ts
===================================================================
--- database/drizzle/queries/builds.ts	(revision dd5067ac93214e993287c1a1356c6c9baf47ffce)
+++ database/drizzle/queries/builds.ts	(revision 82aa6ae699fa11a88a3aa636a5ea3e4a4a41d0a0)
@@ -77,5 +77,6 @@
             name: buildsTable.name,
             created_at: buildsTable.createdAt,
-            total_price: buildsTable.totalPrice
+            total_price: buildsTable.totalPrice,
+            avgRating: sql<number>`COALESCE(AVG(${ratingBuildsTable.value}::float),0)`
         })
         .from(buildsTable)
@@ -84,6 +85,17 @@
             eq(buildsTable.id, favoriteBuildsTable.buildId)
         )
+        .leftJoin(
+            ratingBuildsTable,
+            eq(buildsTable.id, ratingBuildsTable.buildId)
+        )
         .where(
             eq(favoriteBuildsTable.userId, userId)
+        )
+        .groupBy(
+            buildsTable.id,
+            buildsTable.userId,
+            buildsTable.name,
+            buildsTable.createdAt,
+            buildsTable.totalPrice
         )
         .orderBy(