0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

DECLARE @MinScore int = ##MinScore##
DECLARE @MinViews int = ##MinViews##

SELECT 
  P.Id as [Post Link],
  CAST(P.Score AS FLOAT) / CAST(P.ViewCount AS FLOAT) SVRatio,
  P.Score Score,
  P.ViewCount Views,
  P.CreationDate CreationDate
FROM
  Posts P
WHERE
  P.PostTypeId = 1 -- only question posts
  AND P.OwnerUserId = ##userid##
  AND P.Score >= @MinScore
  AND P.ViewCount >= @MinViews
ORDER BY
  SVRatio DESC

fork query

edited oct 23 16

created oct 23 16 jon.doe7173