Index: database/drizzle/queries/builds.ts
===================================================================
--- database/drizzle/queries/builds.ts	(revision e7f1bfa7ce76200b61fe01419065e5b4c1bc1f96)
+++ database/drizzle/queries/builds.ts	(revision dd5067ac93214e993287c1a1356c6c9baf47ffce)
@@ -23,4 +23,7 @@
         .where(
             eq(buildsTable.isApproved, false)
+        )
+        .orderBy(
+            desc(buildsTable.createdAt)
         );
 
@@ -40,4 +43,7 @@
         .where(
             eq(buildsTable.userId, userId)
+        )
+        .orderBy(
+            desc(buildsTable.createdAt)
         );
 
@@ -80,4 +86,7 @@
         .where(
             eq(favoriteBuildsTable.userId, userId)
+        )
+        .orderBy(
+            desc(sql<number>`COALESCE(AVG(${ratingBuildsTable.value}::float),0)`)
         );