Top Latency Spikes by Country

Given a table of message delivery logs, write a query to identify the top three destination countries with the highest latency spikes over the past 48 hours.

Treat a latency spike as a delivery with latency_ms greater than 1000. Rank countries by their maximum spike latency, then by spike count and country code for deterministic tie-breaking.

Output

1. Return one row per destination country, excluding missing country codes and latencies.
2. Include country_code, spike_count, average_spike_latency_ms, and maximum_spike_latency_ms.
3. Return only the top three countries, ordered by maximum spike latency descending, spike count descending, and country code ascending.