Trending SQL

SELECT Runs.GameID, RunsPlayers.UserID, MAX((2^(-2/30.4375))^(Now()-[RunDate])) AS RunActivity30, MAX((2^(-2/14))^(Now()-[RunDate])) AS RunActivity14
FROM Runs INNER JOIN RunsPlayers ON Runs.RunID = RunsPlayers.RunID
WHERE ((NOT (Runs.STATUS)="rejected"))
GROUP BY Runs.GameID, RunsPlayers.UserID;

SELECT Example1.GameID, SUM(Example1.RunActivity30) AS GameActivity30, SUM(Example1.RunActivity14) AS GameActivity14, IIf([GameActivity30]>3,[GameActivity30]/[GameActivity14],9999) AS TrendRatio
FROM Example1
GROUP BY Example1.GameID;

SELECT Example2.GameID, Example2.TrendRatio
FROM Example2
ORDER BY Example2.TrendRatio;