#168 Queries for Employees and Departments

Companies:

OTP Bank

Themes:

SQLJoinsAggregationPractice

The following tables are given:

Employees
id | first_name | last_name | department_number
...

Departments
number | name | location
...

Select employees whose last name starts with "B"
Display the department name instead of department_number
Count employees by city and by department
Select departments with three or more employees and return their counts

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.