Section 02 : Basic Agg : part 04 - P8

Farahat612 · Farahat612 · commit 676f0b5f2369 · 2024-04-07T00:00:05.000+02:00
diff --git a/3. Basic Aggregate Functions/08 550. Game Play Analysis IV.sql b/3. Basic Aggregate Functions/08 550. Game Play Analysis IV.sql
@@ -0,0 +1,17 @@
+SELECT
+  ROUND(
+    COUNT(A1.player_id)
+    / (SELECT COUNT(DISTINCT A3.player_id) FROM Activity A3)
+  , 2) AS fraction
+FROM
+  Activity A1
+WHERE
+  (A1.player_id, DATE_SUB(A1.event_date, INTERVAL 1 DAY)) IN (
+    SELECT
+      A2.player_id,
+      MIN(A2.event_date)
+    FROM
+      Activity A2
+    GROUP BY
+      A2.player_id
+  );
