[리트코드/SQL] 24. Game Play Analysis I (511)

👉 https://leetcode.com/problems/game-play-analysis-i/description/?envType=study-plan&id=sql-i

Game Play Analysis I - LeetCode

---

🤔 문제 분석

1) Write an SQL query to report the first login date for each player.

 

💡 풀이

SELECT player_id, min(event_date) AS first_login
FROM Activity
GROUP BY player_id