restricting queries to avg only cc data