Percentage of posts that mention imgur

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computes the percentage of posts (questions and answers) that match 'imgur' (would be nice to refine it to count actual images).

SharePoint

Q&A for SharePoint enthusiasts

-- Enter Query Title
-- Enter Query Description

select
(select
 cast(count(*) as float)
 from
  Posts
  where Body like '%imgur%')/
(select
 cast(count(*) as float)
 from
  Posts)*100 as [Percentage of posts mentioning imgur]
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results