Q&A about the site for linguists, teachers and students of the Ukrainian language
select top 100 UserId as "User Link", sum(case when Text like '%:-)%' THEN 1 ELSE 0 END) as "Total Smiley" from Comments group by UserId order by "Total Smiley" desc