updated better colour for each school, updated query to use view