Amongst the many related tables that I have in my DB, there are Student and Orders.
With our new, lovely GDPR regulations here in the EU we can't hold onto personal data longer than we really need to.
Relevant fields are :
Valid From (Date Field)
Expires (Date Field)
How could I find the inactive/ latent Students that have not had an order since a specified date?
If I could find these, I could delete the records, en mass.