SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tablename (`row_id` INTEGER, `customer_number` INTEGER, `end_record_date` VARCHAR(12));
✓
INSERT INTO tablename (`row_id`, `customer_number`, `end_record_date`) VALUES
  ('1', '12345', '00:00:00'),
  ('346', '7568', '2021-01-01'),
  ('89', '7568', '00:00:00'),
  ('1287', '12345', '00:00:00');
✓
SELECT customer_number
FROM tablename
GROUP BY customer_number
HAVING SUM(end_record_date = '00:00:00') >= 2;


customer_number


12345


SELECT *
FROM tablename
WHERE customer_number IN (
  SELECT customer_number
  FROM tablename
  GROUP BY customer_number
  HAVING SUM(end_record_date = '00:00:00') >= 2
);


row_id
customer_number
end_record_date


1
12345
00:00:00

1287
12345
00:00:00