We provide parts to customers. Sometimes we keep parts in stock and ship them to them when they need them. I need to be able to ask my database what parts might be in stock for a particular customer that they haven't ordered in the past year (or whatever date). I have a table with my parts. I have a table with orders for those parts. How do I write my query so that I can tell it my customer, tell it the past year, and then it return all the parts that are in inventory that they haven't ordered in the amount of time I ask for?