Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
SELECT TOP (5) ss.site_name, profile = CONCAT(ss.site_url, '/u/', su.user_id), su.reputation, su.question_count, su.answer_count FROM dbo.sede_users AS su INNER JOIN dbo.sede_sites AS ss ON su.site_id = ss.site_id WHERE su.account_id = ##AccountId:int## ORDER BY su.reputation DESC;