SQL> CREATE TABLE customer ( id INT UNSIGNED , year SMALLINT UNSIGNED , revenue DECIMAL(11, 2) , customer_class CHAR(1) ); SQL> INSERT INTO customer VALUES (1, 2016, 100.0), (2, 2016, 0.0), (3, 2016, 999.99); SQL> INSERT INTO customer VALUES (1, 2017, 500.0), (2, 2017, 0.0), (3, 2017, 100.00); SQL> INSERT INTO customer VALUES (1, 2018, 400.0), (2, 2018, 0.0), (3, 2018, 0.0); SQL> SELECT * FROM customer; +---+------+---------+ | id| year | revenue | +---+------+---------+ | 1 | 2016 | 100.00 | | 2 | 2016 | 0.00 | | 3 | 2016 | 999.99 | | 1 | 2017 | 500.00 | | 2 | 2017 | 0.00 | | 3 | 2017 | 100.00 | | 1 | 2018 | 400.00 | | 2 | 2018 | 0.00 | | 3 | 2018 | 0.00 | +---+------+---------+ SQL> DELETE FROM customer WHERE id IN (SELECT id FROM customer GROUP BY id HAVING SUM(revenue) = 0.0);