6. Subqueries | View | Indexes | Performence tips

A subquery (also called a nested query or inner query) is a query written inside another SQL query.The subquery runs first it gives value then outer query use that value Subquery in WHERE - (add some