The challenge is to create a query for a report that show expiring material. There is a table with material that have a expiry date. Another table holds request for the expiring material. You need to show how much material will be expiring that do not have request in queue for.
This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.