It's an easier question to ask; Which songs don't give advise? People try to find meaning in songs where there is NONE. I remember an interview with Paul Simon where he was asked the meaning of "You can call me Al". He shrugged his shoulders after thinking about it and said he didn't have an answer. So many songs were written under the influence of God knows what drug. There's a book I have that a guy wrote explaining the meaning of "American Pie". I asked Don's manager what he thought of it. "Interesting" was his only answer. I can't think of the exact phrase but someone did say "When you completely decipher a song it loses some of its luster" Just a couple of thoughts. Joe 

Let It Be

Somewhere Over the Rainbow

Summertime

ad·vice

/ədˈvīs/

noun

guidance or recommendations offered with regard to prudent future action.

“Just because you've become a young man now
There's still somethings that you don't understand now
Before you ask some girl for her hand now
Keep your freedom for as long as you can now  
My mama told me, you better shop around 
Try to get yourself a bargain, son
Don't be sold on the very first one
Now pretty girls come a dime a dozen
Try to find one who's gonna give you true loving 
Before you take a girl and say "I do" now
Make sure she's in love with you now
My mama told me, you better shop around” 
- Smokey Robinson 

I read this thread, had the perfect song but couldn't remember the title so I left. Now I remember and am back. Here's the song

Tom MacDonald - "Brainwashed"

https://www.youtube.com/watch?v=zCBNwGHPZ2M&ab_channel=TomMacDonald

@cd318 Stop Your Sobbing is by the Kinks and covered by the Pretenders.

But speaking of the Kinks, they have a few songs with good advice:

Have A Cuppa Tea

Skin and Bones

Come Dancing

Better Things

Jukebox Music

Animal Farm

Alcohol

Are the ones I can think of now.