instruction: new answers from the last 48 hours to upvote.
response: SELECT a.Id AS "post_link", CAST((JULIANDAY(CreationDate) - JULIANDAY(CURRENT_TIMESTAMP())) * 24.0 AS INT) AS "time_difference" FROM Posts AS a INNER JOIN Posts AS q ON a.ParentId = q.Id WHERE CAST((JULIANDAY(CreationDate) - JULIANDAY(CURRENT_TIMESTAMP())) * 24.0 AS INT) <= 48 ORDER BY RAND()