0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings

SELECT 
   rank() over (ORDER BY SCORE DESC, ViewCount DESC)
  ,a.Id as [Post Link]
  ,b.DisplayName as UserName
  ,Score
  ,ViewCount
  ,convert(varchar, a.CreationDate, 103) as Date
  ,Tags
FROM Posts a
INNER JOIN Users b ON a.OwnerUserId = b.Id
WHERE
  a.CreationDate between '03-09-2015' and '03-22-2015'
  and PostTypeId = 1
  and Tags like '%creature-design%' 
ORDER BY Score DESC, ViewCount DESC

fork query

edited mar 24 15

created mar 24 15 Serban Tanasa