0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

declare @base int;
select @base = Count FROM Tags WHERE TagName like 'jetbrains%';


select TagName as Tag, Count, (CAST(Count AS float) / @base) as TimesMoreQuestions
from Tags
where TagName like 'intellij-idea%'
  or TagName like 'phpstorm%'
  or TagName like 'webstorm%'
  or TagName like 'resharper%'
  or TagName like 'teamcity%'
  or TagName like 'pycharm%'
  or TagName like 'rubymine%'
  order by Count desc;
  ;

fork query

edited aug 14 13

created aug 14 13 Makoto