oracle sql 逻辑处理

select * from aa where 收货人地址 in (select 收货人地址 from aa) and etdl_end_time in
(select min(etdl_end_time) from aaa where 收货人地址 in (select 收货人地址 from aa) group by 收货人地址 )order by etdl_end_time desc;

select count(*) from aaa