Your question is SQL Join Matching Rows. 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.
Revature’s QA team needs a quick report of candidates who passed the SQL Fundamentals assessment. Write a PostgreSQL query that returns only the matching assessment records.
assessment_name is SQL Fundamentals and whose result is Passed.candidate_name.| Column | Type | Description |
|---|---|---|
| candidate_idPK | INT | Unique candidate identifier |
| candidate_name | VARCHAR(100) | Candidate's full name |
| assessment_name | VARCHAR(100) | Name of the assessment |
| result | VARCHAR(20) | Assessment result, which may be pending |
| completed_on | DATE | Assessment completion date |