Risk Priority Numbers by Date

If @duedate is within 14 days, then show '100', otherwise 0

If @duedate is within 30 days, then show '50', otherwise 0

If @duedate is within 60 days, then show '25', otherwise 0

If @duedate is past due, then show '150', otherwise 0