Exercise 2

This first exercise will test your knowledge of JOINS.

We'll cover the following...

Problem statement

Write a SQL query to fetch employee names having a salary greater than or equal to $40,000 and less than or equal $60,000.

Input

The following tables are available to you as inputs:

EMPLOYEE Table

Em
...

SALARY Table

Emp_
...