leetcode

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README
commit 6d7495d27ba92385425a9f4ba921eb7152d4aab0
parent 8c3de239888904aa4a7ccb16ff368b48c765ee5f
Author: AndrewLockVI <andrewlaack1@gmail.com>
Date:   Fri, 14 Apr 2023 13:00:13 -0500

COmpleted game play analysis

Diffstat:

Agame-play-analysis/game-play-analysis.sql | 6++++++


1 file changed, 6 insertions(+), 0 deletions(-)

diff --git a/game-play-analysis/game-play-analysis.sql b/game-play-analysis/game-play-analysis.sql
@@ -0,0 +1,6 @@
+
+--Write query to find the first login for a user
+--Runtime: 985ms Beats: 44.95%
+SELECT A.player_id, min(A.event_date) first_login
+FROM Activity AS A
+GROUP BY player_id