SQL Join Matching Rows

EasySQL · PostgreSQL

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

Tablescandidate_assessments

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.