A global communications platform wants to find members capable of cross-regional translation. Write a SQL query to return the `user_id` of all users who speak at least two distinct languages from the required target set: 'English', 'Spanish', and 'German'. Sort the results by `user_id` in ascending order. Note: A user might have submitted multiple certifications for the same language, resulting in duplicate entries. Your solution must count unique languages.
Loading…
Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.
Ask questions, share alternate queries, and explore solutions
Your recent query executions and answer checks
This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.