Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
select reinvented.tagname reinvented, 'with' presence, ##Invented:string## invented, count(distinct answerer.id) nanswerers, cast(sum(answers.score) as float) score, --cast(sum(answerer.reputation) as float) reputation, count(distinct answers.id) nanswers, cast(sum(answers.score) as float) / count(distinct answers.id) score_per_answer from tags reinvented, users answerer, posts questions, posts answers, posttags ptri where questions.posttypeid=1 and questions.id = ptri.postid and ptri.tagid=reinvented.id and questions.id=answers.parentid and answers.posttypeid=2 and answers.owneruserid=answerer.id and answerer.reputation between 2 and 100000 and reinvented.tagname = ##Reinvented:string## and ##Invented:string## in (select tagname from tags invented, posttags pti where invented.id=pti.tagid and pti.postid=questions.id) group by reinvented.tagname union select reinvented.tagname reinvented, 'without' presence, ##Invented:string## invented, count(distinct answerer.id) nanswerers, cast(sum(answers.score) as float) score, --cast(sum(answerer.reputation) as float) reputation, count(distinct answers.id) nanswers, cast(sum(answers.score) as float) / count(distinct answers.id) score_per_answer from tags reinvented, users answerer, posts questions, posts answers, posttags ptri where questions.posttypeid=1 and questions.id = ptri.postid and ptri.tagid=reinvented.id and questions.id=answers.parentid and answers.posttypeid=2 and answers.owneruserid=answerer.id and answerer.reputation between 2 and 100000 and reinvented.tagname = ##Reinvented:string## and ##Invented:string## not in (select tagname from tags invented, posttags pti where invented.id=pti.tagid and pti.postid=questions.id) group by reinvented.tagname