I have a query that brings up a job#, its start date (mm/dd/yyyy), and its
priority status (Low, Medium, or High).
Is there SQL I can use to make another query that will look at the start date, and if it is a week old, change the priority status to Medium, and if it's a month old, change the priority to High?