I have two tables - one contains a list of customers, countries, order dates, and delivery dates. The other contains a list of all possible countries and delivery deadlines. I want to determine the number of orders that were filled within the deadline by country. Orders filled after the deadline should be ignored.
The following counts the orders filled, but does not ignore the orders filled after the deadline.