vba questions with high views, low answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

potential game criteria?

Amateur Radio

Q&A for amateur radio enthusiasts

select 
  Tags,
  id,
  viewcount as Views,
  answercount as Answers,
  cast(creationdate as date) as Asked,
  title
into #temp from posts
where 
  ( tags like '%excel%' or tags like '%vba>%' )
  and answercount<3     --less than 3 answers
  and posttypeid=1      --questions 
  and viewcount>=1000   --at least 1000 views
  and closeddate is null and communityowneddate is null
  and tags not like '%php%'     and tags not like '%java%'
  and tags not like '%python%'  and tags not like '%interop%'
  and tags not like '%asp.net%' and tags not like '%c#%'

select top 10000
  round(1.0*datediff(d,asked,getdate())/365,1) as [years old],
  format(asked,'yyyy-MMM-dd') as Asked,
  'https://stackoverflow.com/q/' + CAST(Id AS nvarchar) + '|' + title AS [Link],
  Views,
  Answers,
  Tags,
  views * cast(1.0*datediff(d,asked,getdate())/365 as int) as [PotentialGamePoints]
from #temp
order by  --year(asked) desc, month(asked)/4 desc, 
  round(views/10000,0) desc,
  round(1.0*datediff(d,asked,getdate())/365,1) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results