#222 Average Salary of Java Vacancies by IT Companies

Companies:

Sberbank Cyberlab

Themes:

SQLJoinsAggregationPractice

The following tables are given:

Company
id | title | sector
...

Vacancy
id | id_company | name | salary
...

Write a query that returns a list of companies from the IT sector, together with the average salary for vacancies whose title contains the word java, where the average salary is greater than $1000.

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.