A CRM export has duplicate customers: the same name (ignoring case) signed up more than once. Keep only the most recent sign-up for each name (latest signup_date; if those tie, the higher id). Return id, name, country and signup_date for the kept rows, sorted by id.
Schema
customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)