Quantum collision-resistance of non-uniformly distributed functions: upper and lower bounds