1 files changed, 6 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql
index 1e49780..45ac46f 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -265,6 +265,12 @@ FROM submissions
 WHERE game_id = $1
 ORDER BY created_at DESC;
 
+-- name: GetLatestSubmissionsByGameID :many
+SELECT DISTINCT ON (user_id) *
+FROM submissions
+WHERE game_id = $1
+ORDER BY user_id, created_at DESC;
+
 -- name: GetSubmissionByID :one
 SELECT *
 FROM submissions