Query Help

[matchoo]

Hi there.

 

I need some SQL advice.

 

I have a database of website usage data.

 

There is a table named 'pages' and it has the following columns:

 

page_id

date_logged

comment_count

view_count

 

I have been asked to figure out if comments are a predictor of page popularity (view counts). 

 

I would like to do a query that returns week to week variance numbers for comments and views and chart it.  Then sort by highest current view counts.

 

Does that sound like a good way of getting this information?  Anyone feel like throwing a SQL query up to show an example of what that might look like?

 

Thanks,

 

Matchoo

[Wildbug]

SELECT YEARWEEK(date_logged) AS week, COUNT(*), SUM(comment_count), SUM(view_count), VAR_POP(comment_count), VAR_POP(view_count) FROM pages GROUP BY YEARWEEK(datelogged);