#6 Employees Who Know SQL and Another Language

Companies:

Wildberries

Themes:

SQLAggregationPractice

There is an Employee table containing records about employees who know programming languages

Name | Lang

Nick C#
Nick SQL
Eva Rust
Vika Kotlin
Vika SQL
... ...

Write a query that selects the names of employees who know SQL and at least one other language. Assume that one employee corresponds to one name.

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.