From cea354fc5e32667786c4a4c9f379b46b3de87ec4 Mon Sep 17 00:00:00 2001
From: Dennis Kobert <dennis@kobert.dev>
Date: Sun, 10 Oct 2021 18:03:49 +0000
Subject: Change deployment

---
 sql/query.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 sql/query.sql

(limited to 'sql/query.sql')

diff --git a/sql/query.sql b/sql/query.sql
new file mode 100644
index 0000000..5582f17
--- /dev/null
+++ b/sql/query.sql
@@ -0,0 +1,18 @@
+WITH users AS (
+                   SELECT *
+                   FROM ( VALUES ('Dennis'), ('Lam') ) AS _ (user_id)
+               )
+                 SELECT track_id, name, artist
+                 FROM track
+                 JOIN (
+                 SELECT track_id
+                 FROM user_track
+                 JOIN suser USING (user_id)
+                 JOIN track USING (track_id)
+                JOIN lobby USING (lobby_id)
+                WHERE suser.user_name IN (SELECT * FROM users)
+                GROUP BY track_id
+                HAVING COUNT(track_id) = (SELECT COUNT(*) FROM users)
+                ORDER BY EXP(SUM(LN(score))) DESC
+                ) AS _ USING (track_id)
+                ;
-- 
cgit v1.2.3-54-g00ecf

