Delete duplicate emails from Contacts_list

Hi all,

How could I create a sql to return duplicate email_address_, opt-In, deliverable, with riid_
Our intention is to delete duplicate emails and leave only the one created with the oldest date.

I have this example, but it returns the full list and without riid_

select email_address_, count(*) total from $A$

group by email_address_

order by count(*) desc

it's possible? Can you help me please!

Many thanks!