Your question is Simple SQL 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.
Blackstone Talent Group needs a simple view of active Software Engineer candidates submitted during the current recruiting period. Write a PostgreSQL query that returns the selected candidate details from the candidate_submissions table.
role_title is Software Engineer, whose status is Submitted, and whose submitted_at is on or after January 1, 2025.candidate_name, role_title, and submitted_at in ascending submission-date order. Use candidate name as a tie-breaker.| Column | Type | Description |
|---|---|---|
| submission_idPK | INT | Unique submission identifier |
| candidate_name | VARCHAR(100) | Candidate's full name |
| role_title | VARCHAR(100) | Role associated with the submission |
| status | VARCHAR(30) | Current recruiting status |
| submitted_at | DATE | Date the candidate was submitted |