Exercise 2
Practice constructing SQL queries to retrieve employee names with salaries between $40,000 and $60,000. Understand how to work with multiple tables and apply conditional filtering in SQL for effective data retrieval.
We'll cover the following...
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_ |
|---|