SQL Queries #2

SQL query to fetch employee names having salary greater than or equal to 10000 and less than or equal 30000.

Query:-

SELECT emp_id, emp_name FROM emp WHERE emp_id IN (SELECT empid FROM sal WHERE salary BETWEEN 10000 AND 30000);