How to properly filter columns after applying aggregate function
I think you can achieve this result without so many subqueries:

Select State
  From Customer
  Group By State
  Order By Count(*) Desc
  Limit 1;