Q&A about the site for Ubuntu users and developers
SELECT Top 30000 Questions.Id AS [Post Link], Questions.Id as Id, Questions.ViewCount as ViewCount, Questions.Score as Score, Questions.Body as Body, Questions.Title as Title, ROUND(1.0 * Questions.Score/Questions.ViewCount, 8) AS scTovc FROM Posts AS Answers INNER JOIN Posts AS Questions ON Questions.Id = Answers.ParentId WHERE ROUND(1.0 * Questions.Score/Questions.ViewCount, 8) < -0.01 GROUP BY Questions.Id, Questions.ViewCount, Questions.Score, Questions.Body, Questions.Title ORDER BY NEWID();