WooCommerce - SQL to Delete users with no orders or posts

query.sql

DELETE from wp_users where wp_users.ID not in (
	SELECT meta_value FROM wp_postmeta WHERE meta_key = '_customer_user'
) AND wp_users.ID not in (
	select distinct(post_author) from wp_posts
);

delete from wp_usermeta where wp_usermeta.user_id not in (select ID from wp_users);

For multisites (replace XX with site id):

delete u from wp_users u join wp_usermeta um on u.ID = um.user_id
left join wp_XX_posts p on u.ID = p.post_author and p.post_type = 'shop_order'
where um.meta_key = 'wp_XX_capabilities' and um.meta_value LIKE '%customer%' and p.ID is null ;

delete from wp_usermeta where wp_usermeta.user_id not in (select ID from wp_users);