These data do show a positive correlation between state alcohol consumption and state IQ. However, the children taking IQ tests and academic assessments is a different population than the one used for measuring alcohol consumption.

In general, I think the relationship between all of these measures could make a good example of Simpson’s paradox. It’s likely completely different correlations could be supported if the data were analyzed at the county level or if it were possible to completely disaggregate down to individuals.