I need a specific query containing information from two tables, and I'm struggling to work out how to achieve it. The tables hold data representing sales of software products which are sold on an renewable annual subscription basis.
The first table is called "CONTRACTS". It contains information...