In MySQL we found sub-queries.

Syntax – Sql-query1 WHERE attribute_name IN (sql-query2);

Lets see another query.

but one thing remember , for exam prospective you need to practice maximum number of SQL sub-queries.