Develop a query which will identify and mark inactive those customers which have bills overdue by more than 30 days (this can generally be done by using a sub-query). Keep in mind, you are only marking a customer as inactive, not really deleting the customer record from the system.