Write a SQL query using a subquery or CTE to join one table to another and apply a filter.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.