Fix sql code

1 files changed, 18 insertions, 0 deletions

diff --git a/sql/new.sql b/sql/new.sql
new file mode 100644
index 0000000..57d918b
--- /dev/null
+++ b/sql/new.sql
@@ -0,0 +1,18 @@
+WITH users AS (
+            SELECT *
+			    FROM ( VALUES ('dennis'), ('caitriao') ) 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 user_name FROM users) AND token = 'shnPcxQ7REwF3QL1T65mcqPtf3k='
+			GROUP BY track_id
+			HAVING COUNT(track_id) = (SELECT COUNT(*) FROM users)
+			ORDER BY SUM(score) DESC
+			) AS _ USING (track_id)
+			;