matchoo Posted June 6, 2007 Share Posted June 6, 2007 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 Link to comment https://forums.phpfreaks.com/topic/54455-query-help/ Share on other sites More sharing options...
Wildbug Posted June 6, 2007 Share Posted June 6, 2007 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); Link to comment https://forums.phpfreaks.com/topic/54455-query-help/#findComment-269350 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.