SQLQuokka
Start practicing
QuestionsLearnSandboxFeaturesRoadmapFAQ

Multilingual Language Speakers

Unsolved

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.

SQL Query Editor (Ctrl+Enter to run)
0 characters · Valid
Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments
Asked By:
🏢 Google

Submission History

Your recent query executions and answer checks

Execution Pipeline:
FROM user_languages
Full source dataset
11 rows total
Ready. Type a query to see live execution.
Clause: Auto-Sync · AlaSQL Engine