mariadb-columnstore-engine/dbcon/dmlpackage/sql/d02.sql

DELETE FROM supplier
WHERE EXISTS
  ( select customer.name
     from customer
     where customer.customer_id = supplier.supplier_id
     and customer.customer_name = 'IBM' );