Valid Message Routing Keys

Problem

An internal messaging bus routes traffic using a `handle` shaped like `local@server.net`. A handle is considered **valid** only when ALL of these hold: it contains exactly one `@`; the part before the `@` uses only letters, digits, or underscores; the part after the `@` (the server) uses only letters; and it ends in `.net`. Return `record_id` and `handle` for every valid routing key, ordered by `record_id` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns record_id, handle.

Starter code (SQL)

SELECT *
FROM routing_keys;

Related SQL questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• App Ad Click-Through RateEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy