Source/NuGetGallery.Operations/Scripts/DownloadReport_RecentPopularityByPackage.sql

SELECT Dimension_Package.PackageVersion, SUM(DownloadCount) 'Downloads'
FROM Fact_Download
INNER JOIN Dimension_Package ON Dimension_Package.Id = Fact_Download.Dimension_Package_Id
INNER JOIN Dimension_Date ON Dimension_Date.Id = Fact_Download.Dimension_Date_Id
WHERE Dimension_Date.[Date] >= CONVERT(DATE, DATEADD(day, -42, GETDATE()))
  AND Dimension_Date.[Date] < CONVERT(DATE, GETDATE())
  AND Dimension_Package.PackageId = @PackageId
GROUP BY Dimension_Package.PackageVersion
ORDER BY SUM(DownloadCount) DESC