It is important to realize that the inner Query will be run first and will be replaced by the query results when the outer query is run
Here is the SubQuery
A SELECT in a SELECT
I Got 23 Results, but I Decided Just Meeting the Average was not good enough for me, I only want the States that were in the top Quarter
I will improve my Sub Query by Dividing the Average by 2