Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings
rank() over (ORDER BY SCORE DESC, ViewCount DESC)
,a.Id as [Post Link]
,b.DisplayName as UserName
,convert(varchar, a.CreationDate, 103) as Date
FROM Posts a
INNER JOIN Users b ON a.OwnerUserId = b.Id
a.CreationDate between '03-09-2015' and '03-22-2015'
and PostTypeId = 1
and Tags like '%creature-design%'
ORDER BY Score DESC, ViewCount DESC