select *,100.0*anzahl/sum(anzahl)over() bewertung from( s...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

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;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results