pokus

0

Please login or register to vote for this query.

(click on this box to dismiss)

Latin Language

Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language

select top 3 u.Id, p.Title, p.ViewCount
from users u
 JOIN posts p ON u.Id = p.OwnerUserId
where p.ViewCount > 0
and p.CreationDate > DATEADD(MONTH, -3, GETDATE())
order by ROW_NUMBER() OVER (PARTITION BY u.ID ORDER BY p.ViewCount DESC)

Enter Parameters

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