0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of Ethereum, the decentralized application platform and smart contract enabled blockchain

with new as( select t.TagName name, count(p.Id) cnt
from Posts p join PostTags pt on p.Id=pt.PostId
     join Tags t on pt.TagId=t.Id
where p.Tags like '%<mysql>%' and t.TagName <>'my sql'
group by t.TagName)
select name, cnt
from new
order by cnt DESC
/*where cnt = (select max(cnt)
           from new)*/

fork query

edited dec 16 17

created dec 16 17 anonymous