How to write SubQuery in SQL? Correlated vs Noncorrelated Sub Query Example

How to write SubQuery in SQL? Correlated vs Noncorrelated Sub Query Example