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