Tag new question activity

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

SELECT
    right(left(CreationDate,11),4) as Year,
    Count(id) as PostCount, 
    Count(id)/365 as AveragePostsPerDay,
    SUM(ViewCount) as Views,
    SUM(ViewCount)/365 as ViewsPerDay
FROM
    Posts
WHERE
    Tags like '%php%'
GROUP BY right(left(CreationDate,11),4)
order by right(left(CreationDate,11),4) desc;

Enter Parameters

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