Canon Elph Video
makes the Canon PowerShot SD 790 IS Digital Elph have good videos at concerts?

I'm asking for is good sound quality and rock concerts and the video is very clear what I am asking is how the sound quality is clear and very clear video

Not especially, but not any video camera no. Compared to other digital cameras is probably in the higher range, however.