MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Client (
  id INT
);

CREATE TABLE Invoice (
  id INT,
  client_id INT,
  invoice_date DATE
);

INSERT INTO Client VALUES
  (1), (2), (3);

INSERT INTO Invoice VALUES
  (1, 1, '2010-02-02'),
  (2, 1, '2009-02-02'),
  (3, 2, '2009-02-02'),
  (4, 3, '2010-02-02');
SELECT *
FROM Client
WHERE NOT EXISTS (
  SELECT 1 FROM Invoice 
  WHERE Invoice.invoice_date > '2010-01-01' AND Invoice.client_id = Client.id
)


id


2


-- CASE
SELECT c.id, SUM(CASE WHEN i.invoice_date > '2010-01-01' THEN 1 ELSE 0 END) AS cnt 
FROM Client AS c LEFT JOIN Invoice i ON i.client_id = c.id 
GROUP BY c.id
HAVING cnt = 0


id
cnt


2
0


-- IF
SELECT c.id, SUM(IF(i.invoice_date > '2010-01-01', 1, 0)) AS cnt 
FROM Client AS c LEFT JOIN Invoice i ON i.client_id = c.id 
GROUP BY c.id
HAVING cnt = 0


id
cnt


2
0


-- CASE
SELECT client_id, COUNT(CASE WHEN invoice_date > '2010-01-01' THEN 1 ELSE NULL END) as cnt 
FROM Invoice
GROUP BY client_id HAVING cnt = 0


client_id
cnt


2
0


-- IF
SELECT client_id, COUNT(IF(invoice_date > '2010-01-01', 1, NULL)) as cnt 
FROM Invoice
GROUP BY client_id HAVING cnt = 0


client_id
cnt


2
0