Your question is SQL Sort Query. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Thales Ground Master radar systems record signal readings from monitored tracks. Write a PostgreSQL query that returns the readings sorted by signal strength from the lowest value to the highest value.
sensor_id, radar_name, and signal_strength from radar_readings.signal_strength in ascending order, place NULL values after known readings, and use sensor_id as a tie-breaker.| Column | Type | Description |
|---|---|---|
| sensor_idPK | INT | Unique identifier for the radar reading |
| radar_name | VARCHAR(100) | Name of the Ground Master radar station |
| signal_strength | NUMERIC(6,2) | Recorded signal strength, which may be unknown |
| recorded_at | TIMESTAMP | Timestamp when the reading was captured |