select
user_id, elo_rating
, users.username
from BI_ANALYTICS.CONTENT_RANKINGS.ELO_RATINGS rats
join BI_ANALYTICS.FLIPSIDE_APP_PROD.USERS users
on rats.user_id = users.id
where elo_rating IS NOT NULL
and project_name = 'Overall'
order by elo_rating desc;