Write a SQL query to identify all engines that experienced a temperature spike above a certain threshold for three consecutive flights at Rolls-Royce. Treat temperatures above 900 C as spikes, and determine consecutiveness from each engine's flight sequence.
engine_id, engine_name, first_streak_start_date, last_streak_end_date, and qualifying_streak_count.engine_id ascending.| Column | Type | Description |
|---|---|---|
| engine_idPK | VARCHAR(20) | Unique engine identifier |
| engine_name | VARCHAR(100) | Engine model name |
| Column | Type | Description |
|---|---|---|
| flight_idPK | INT | Unique flight identifier |
| engine_id | VARCHAR(20) | Engine assigned to the flight |
| flight_date | DATE | Date of the flight |
| flight_sequence | INT | Chronological sequence number for the engine |
| Column | Type | Description |
|---|---|---|
| reading_idPK | INT | Unique temperature reading identifier |
| flight_id | INT | Flight associated with the reading |
| engine_id | VARCHAR(20) | Engine that produced the reading |
| max_temperature_c | DECIMAL(6,2) | Maximum recorded temperature in Celsius |