The SCUBA-2 Cosmology Legacy Survey: demographics of the 450-μm population