Tracing star formation and AGN activity at radio frequencies