Validity Customer Community

Hello all, is there a way to query the number of Opportunities an Account has and then delete the Account if the number is 0 (among other criteria)? We are wanting to automatically delete dormant Accounts using dtv.