Cacher is the code snippet organizer for pro developers

SELECT 
 name, COUNT(play_log.game_id) AS NumberOfPlays 
FROM play_log
 LEFT JOIN game ON play_log.game_id = game.id
GROUP BY NAME
HAVING COUNT(play_log.game_id) > 0