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);