Maciej Twardowski - WP Zadania Rekrutacyjne SQL

SELECT
  EXTRACT(YEAR FROM aggregate_date) AS YEAR,
  SUM(clicks) AS clicks,
  SUM(shows) AS shows,
  SUM(clicks) / SUM(shows) AS CTR
FROM user_actions
GROUP BY EXTRACT(YEAR FROM aggregate_date);

SELECT
  EXTRACT(YEAR FROM aggregate_date) AS YEAR,
  SUM(clicks) / SUM(shows) AS CTR
FROM user_actions
WHERE section = 'Sport'
GROUP BY EXTRACT(YEAR FROM aggregate_date)
ORDER BY EXTRACT(YEAR FROM aggregate_date) DESC;