Solution to Exercise 2
Solution to exercise 2.
We'll cover the following...
Solution #1
Press + to interact
SELECT E.FULL_NAME, S.SALARYFROM EMPLOYEE AS EINNER JOIN SALARY AS SON E.EMP_ID = S.EMP_IDWHERE S.SALARY >= 40000 AND S.SALARY <= 60000
The solution will also work without using the aliases as seen below: ...