LeetCode Database知识点总结 - 511

LeetCode 511. Game Play Analysis I

考点	难度
Database	Easy

题目

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

Return the result table in any order.

The query result format is in the following example.

思路

无

答案

select player_id, min(event_date) as first_login
from activity
group by player_id