instruction: Biblical Hermeneutics > Top 50 Posts by Views per day.
response: SELECT P.Id AS "post_link", P.Title, P.ViewCount, P.Score, CAST(CURRENT_TIMESTAMP() - P.CreationDate AS INT) AS "days_active", ViewCount / CAST(CURRENT_TIMESTAMP() - P.CreationDate AS INT) AS "average_views_per_day", U.DisplayName FROM Posts AS P INNER JOIN Users AS U ON P.OwnerUserId = U.Id ORDER BY P.ViewCount / CAST(CURRENT_TIMESTAMP() - P.CreationDate AS INT) DESC LIMIT 50