Recently I've had an influx of spam users registering on my Wordpress website and I am trying to delete them all if:
- they have a "Customer" role
- haven't placed at least one order before
As I could not find a suitable plugin for this, I imagine an SQL query would be the fast options. Can anyone please help with what should I query to ensure I delete only Customers and not admins that haven't placed an order before.