Advanced · SQL · Data quality

Deactivated customers who still ordered

Commonly asked: Business-rule validation questions · ~9 min

Return id, name and orders (count) for customers with is_active = 0 or a non-null deleted_at who have at least one order. Sort by id.