Athena looking for records with different start dates

I have a lot of customer files with I customer data that includes a customer id which can have multiple service points. A service point can have a meter and a meter can have a meter install date:

I'm trying to find the number of meters that have a multiple install dates. It is not uncommon to have multiple rows where these field's information is duplicated. As I try different strategies I get different answers so I'm doing something wrong.

I've tried:

select customer_id, service_point_id, secondary_sp_id
from customer
where secondary_sp_id in (
  select secondary_sp_id
  from customer
  group by secondary_sp_id
  having length(secondary_sp_id) > 1 and count(distinct meter_install_date) > 1

select customer_id, service_point_id, secondary_sp_id, meter_install_date
from customer
where secondary_sp_id in (
select secondary_sp_id
from customer
group by secondary_sp_id having count(distinct meter_install_date) > 1 )

select a.service_point_id, a.secondary_sp_id, a.meter_install_date 
from customer a, customer b 
where a.service_point_id = b.service_point_id 
and a.secondary_sp_id = b.secondary_sp_id 
and a.meter_install_date != b.meter_install_date 
group by a.service_point_id, a.secondary_sp_id, a.meter_install_date

I would expect to get back:

I don't think I'm handling when a service point has multiple meters and one of those meters has multiple start dates. Thanks for your help!

I'm not sure we have enough information of your data or schema, such as how "secondardy_sp_id" fits into this. No details were provided on that column nor the prod_peco_customer table.

If we assume your data appears like your first formatted section in the question, then the following CTE would work as-is.

create table customer (
  cust integer, 
  service_point varchar(5), 
  meter_id varchar(5), 
  meter_install_date date
  );
  
insert into customer values 
(1, 'A1', 'AM1', '20201005'),
(1, 'A1', 'AM1', '20150101'),
(1, 'A2', 'AM2', '20230110');

with target_meters as (
  select meter_id
  from customer
  group by meter_id
  having count(distinct meter_install_date) > 1
  )
select c.*
from customer c
join target_meters t
  on c.meter_id = t.meter_id;

But I kinda doubt your data looks like this even though you formatted it that way in the question. Adjust accordingly, but main point is that you could use a sub-query or CTE for identifying your meters with multiple install dates.

----------Update-----------

Based on the updated sample data, then you would simply need to change select c.* to select distinct c.* such as this...

with target_meters as (
  select meter_id
  from customer
  group by meter_id
  having count(distinct meter_install_date) > 1
  )
select distinct c.*
from customer c
join target_meters t
  on c.meter_id = t.meter_id
order by 1,2,3,4