This is for a class so I would prefer hints or something to read rather than just the answer unless it is just an obvious mistake. The parser is getting confused between DATE and VARCHAR I believe it is because they both start with a tick mark (') and end with a tick. I can not change the syntax it needs to stay this way