with upc as ( select users.id from users inner join posts...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

with upc as (
  select users.id
  from users inner join posts on posts.owneruserid = users.id
  where
      users.id > 10000000
  and UpVotes > 3
  and DownVotes = 0
  and Reputation < 150
  and left(Users.ProfileImageUrl, 32) =  'https://www.gravatar.com/avatar/'
  group by users.id
  having count(posts.id) = 1
)

select
    posts.id as [Post Link]
  , posts.Score
  , posts.Tags
  , posts.owneruserid as [User Link]
  , posts.ViewCount
  , posts.CreationDate
  , format(
        cast(posts.ViewCount as float) / posts.Score
      , 'N2'
    ) as ratio
from Posts
inner join upc on posts.owneruserid = upc.id
where
    posts.score >= 4
and posts.PostTypeId = 1 -- questions
and posts.ViewCount < 200
order by cast(posts.ViewCount as float) / posts.Score asc

Enter Parameters

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