Niche appears to compare across the country, and greatschools looks to compare with the state. It's likely that a school that greatschools gives a terrible grade might be top tier elsewhere.
As another said, it's also impacted by ESL kids (English as a Second Language).