MySQL: What Are Sub Queries & How Are They Used?

I have had a few questions recently asking what sub queries are and how they are used. While there are a number of articles out there on the subject they don’t explain it in a detailed manner as I would like. So here is my take on them.