sql correlated subquery code example

Example: What is Correlated Subquery in DBMS?

SELECT * from EMP WHERE ‘RIYA’ IN (SELECT Name from DEPT WHERE EMP.EMPID=DEPT.EMPID);