Based on the data I have on majors, chemistry is very underrepresented (even more so than physics) in Columbia College. Only around 0.25% of the class majors in chem each year. Chemical engineering is a very popular major in SEAS, though.
I choose chem as my major for CC.