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).

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- 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 sites:
loading Hold tight while we fetch your results