leetcodeSolution to some Leetcode problems written in C++ |
| git clone git://git.dimitrijedobrota.com/leetcode.git |
| Log | Files | Refs | README | LICENSE | |
0550.sql (277B)
1 SELECT ROUND(COUNT(DISTINCT player_id) / (SELECT COUNT(DISTINCT player_id) FROM Activity), 2) AS fraction 2 FROM Activity 3 WHERE (player_id, DATE_SUB(event_date, INTERVAL 1 DAY)) IN ( 4 SELECT player_id, MIN(event_date) as first_date 5 FROM Activity 6 GROUP BY player_id 7 ) 8