Write a query to find the second-highest credit score from a customer database.
Use the customers and credit_scores tables. Treat the second-highest value as the second-highest distinct non-NULL credit score.
second_highest_credit_score.| Column | Type | Description |
|---|---|---|
| customer_idPK | INTEGER | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer full name |
| Column | Type | Description |
|---|---|---|
| score_idPK | INTEGER | Unique credit score record identifier |
| customer_id | INTEGER | Customer associated with the score |
| credit_score | INTEGER | Customer credit score |