XML Data Handling in SQL

Tell me about how you handle XML data in your data analysis work using SQL or related tooling.

For this exercise, work with the XML payloads stored in Boeing maintenance event records. Write a SQL query that extracts the event type, tail number, and event timestamp from the XML, keeps only rows with all three values present, and returns the latest valid record for each source system.

Output

1. One row per source_system
2. Columns: source_system, event_type, tail_number, event_ts
3. Keep only rows where all extracted values are present and event_ts is not null
4. If multiple valid rows exist for a source system, return the most recent event_ts
5. Sort by source_system ascending