I appreciate the assistance.

Am I to assume the "123" is where I insert the

MAX(in_view.temp)

FROM (SELECT temp = COUNT(state)

FROM stores

GROUP BY state) AS in_view

On a side note, I did manage...