Examining the Planned Inner Query

I Start by looking at my data, so here are my fields

I Always want to use these fields because they are normalized, If I do not the States Population will skew the results

So I know I do not want to live anywhere that cannot atleast be below the national average , so I will focus on Deaths and find the average

So Using the AVG function I can see that the Average is 1821 Deaths

Now I am going to use this in a SubQuery