Explain how you would write a basic SQL query to retrieve the data you need.
Use the security_findings table to retrieve open findings with a risk score of at least 70. Return only the requested columns and exclude rows with missing filter values.
finding_id, asset_name, severity, and risk_scorerisk_score descending, then finding_id ascending| Column | Type | Description |
|---|---|---|
| finding_idPK | INT | Unique security finding identifier |
| asset_name | VARCHAR(100) | Name of the affected asset |
| severity | VARCHAR(20) | Severity classification |
| status | VARCHAR(20) | Current finding status |
| risk_score | INT | Numeric risk score from 0 to 100 |
| discovered_on | DATE | Date the finding was discovered |