SQL crud hw

Lines 63 and 70 (commented out) do not work; couldn't figure out how to do dates between a week ago and now in SQL, and all attempts to order payments descending failed. Otherwise this assignment was pretty straight forward, I thought.