Q&A for science fiction and fantasy enthusiasts
select *,100.0*anzahl/sum(anzahl)over() bewertung from( select tagname,count(*) anzahl from Posts p inner join PostTags on p.id=postid inner join Tags t on t.id=tagid where tagname in( 'assambly','c','c#','c++','cobol', 'd','dart','object-pasacal','go','groovy', 'java','javascript','labview','matlab','objective-c', 'perl','php','plsql','python','r', 'ruby','sas','scala','mit-scratch','sql', 'swift','vba','vb.net') and creationdate between cast(##lowerDate## as date) and cast(##upperDate## as date) group by tagname) q1 order by anzahl desc;