Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
views_days as (
cast(viewcount as float) as views,
datediff(day, creationdate, GetDate()) as age_in_days
posttypes pt on p.posttypeid = pt.id
pt.name = 'Question'
and p.tags like '%<joomla>%'
round(avg(views / age_in_days), 3) as average_views_per_day