Solve Your Every Day Technical Problem

Question and Answer(SQL JOINING) 1. View the Exhibit and examine the structure of the EMP and SALGRADE tables. You want to display the names of all employees whose salaries belong to GRADE 5. Which SQL statements give the required output? (Choose all that apply) SELECT ename FROM emp JOIN salgrade USING (sal BETWEEN losal AND hisal) AND grade = 5; SELECT ename FROM emp e JOIN salgrade s ON (e.sal BETWEEN s.losal AND s.hisal AND s.grade = 5); SELECT ename FROM emp e JOIN salgrade s ON (e.sal BETWEEN s.losal AND s.hisal) AND s.grade = 5; SELECT ename FROM emp e JOIN salgrade s ON (e.sal BETWEEN s.losal AND s.hisal) WHERE s.grade=5; SELECT ename FROM emp e JOIN salgrade s WHERE e.sal BETWEEN s.losal AND s.hisal AND s.grade = 5; table "Exhibit"  EMP Name Null? Type ...