Database Design Fundamentals for Software Engineers/

...

/

Solution to Exercise 2

Solution to Exercise 2

Solution to exercise 2.

We'll cover the following...

Solution #1

MySQL
SELECT E.FULL_NAME, S.SALARY
FROM EMPLOYEE AS E
INNER JOIN SALARY AS S
ON E.EMP_ID = S.EMP_ID
WHERE S.SALARY >= 40000 AND S.SALARY <= 60000

The solution will also work without using the aliases as seen below: ...