SELECT
    project_name,
    MOD(days_remaining, 7) AS days_until_weekend
FROM projects;