Тестовое задание
на продуктового аналитика
Nexters

def filter_active_players(active_days_list):
return __________

def increase_AoV_with_bonus(aov, has_bonus):
return __________

1. SELECT game_name, SUM(revenue)
   FROM game_sales
   GROUP BY game_name HAVING SUM(revenue) > 50000;`

2. SELECT game_name
   FROM game_sales
   GROUP BY game_name WHERE SUM(revenue) > 50000;

3. SELECT game_name, revenue
   FROM game_sales
   WHERE revenue > 50000
   GROUP BY game_name;

4. SELECT game_name, SUM(revenue) > 50000
   FROM game_sales
   GROUP BY game_name;

1. SELECT *
   FROM games
   WHERE revenue_per_user > (SELECT AVG(revenue_per_user) FROM games);

2. SELECT *
   FROM games
   WHERE revenue_per_user > AVG(revenue_per_user);

3. SELECT *
   FROM games
   WHERE revenue_per_user IN (SELECT revenue_per_user
                              FROM games
                              WHERE revenue_per_user > AVG(revenue_per_user));

4. SELECT *
   FROM games
   WHERE revenue_per_user > ALL (SELECT AVG(revenue_per_user) FROM games);

1. SELECT player_name
   FROM active_players
   UNION
   SELECT player_name
   FROM paying_players;

2. SELECT player_name
   FROM active_players
   JOIN paying_players
   ON active_players.player_name = paying_players.player_name;

3. SELECT player_name
   FROM active_players
   UNION ALL
   SELECT payer_name
   FROM paying_players;

4. SELECT DISTINCT player_name
   FROM active_players
   UNION paying_players;