SQL Join Matching Rows | Dataford Interview Questions

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.

Requirements

Return candidates whose assessment_name is SQL Fundamentals and whose result is Passed.
Return the matching rows ordered alphabetically by candidate_name.

Schema

candidate_assessments

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

Your question is SQL Join Matching Rows. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

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.

Requirements

Return candidates whose assessment_name is SQL Fundamentals and whose result is Passed.
Return the matching rows ordered alphabetically by candidate_name.

Schema

candidate_assessments

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

Your question is SQL Join Matching Rows. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.