How to write SQL Subqueries?

Although when you think about which one executes faster & retrieval time of the query using joins vs subquery, join always wins. but in some cases using subqueries is a wise decision instead of join because of some obvious reasons like joins can get ...