0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who use Blender to create 3D graphics, animations, or games

SELECT TOP 100
    p.OwnerUserId,
    p.Id,
    p.Title,
    p.ViewCount
FROM Posts p
WHERE 
    p.CreationDate >= DATEADD(MONTH, -3, GETDATE()) 
    AND p.ViewCount > 0
ORDER BY p.OwnerUserId, p.ViewCount DESC;

fork query

edited aug 10

created aug 2 anonymous