Tell me about your experience with Java 8, lambdas and streams, PreparedStatement, and SQL.
For the SQL portion, write a query that summarizes qualifying respondent responses during January 2025. Include only active respondents with at least two completed responses having non-NULL scores.
respondent_name, region, completed_response_count, average_score, latest_response_date, and score_band.high; all other included averages are low.average_score descending, then respondent_name ascending. Ignore rows with a NULL average score.| Column | Type | Description |
|---|---|---|
| respondent_idPK | INT | Unique respondent identifier |
| respondent_name | VARCHAR(100) | Respondent's display name |
| region | VARCHAR(50) | Respondent region |
| status | VARCHAR(20) | Respondent status |
| Column | Type | Description |
|---|---|---|
| response_idPK | INT | Unique response identifier |
| respondent_id | INT | Respondent associated with the response |
| response_date | DATE | Date the response was recorded |
| response_status | VARCHAR(20) | Processing status of the response |
| score | NUMERIC(4,2) | Numeric response score |