SELECT a.game_id, sum(a.daily_views), g.title
FROM game_activity a
WHERE a.date >= (DATE(NOW()) - INTERVAL 3 DAY)
LEFT JOIN games g ON g.id=a.game_id
GROUP BY a.game_id
ORDER BY a.daily_views DESC LIMIT 3