Singer-songwriter wrote Elvis Presley's indelible "In the Ghetto" alongside solo hits like "Baby Don't Get Hooked on Me" and "Stop and Smell the Roses"