instruction: View percentiles for bountied questions.
response: WITH BountiedPosts AS (SELECT p.* FROM Posts AS p JOIN Votes AS v ON v.PostId = p.Id AND v.VoteTypeId = 8 WHERE p.Score >= 0 AND ClosedDate IS NULL), Percentiles AS (SELECT NTILE(100) OVER (ORDER BY ViewCount) AS Percentile, ViewCount FROM BountiedPosts) SELECT MIN(ViewCount) AS NumberOfViews, Percentile FROM Percentiles GROUP BY Percentile ORDER BY Percentile