How do you calm your kids down when they have a bad nightmare in middle of the night?

We still have this issue with our daughter Normally we sing or play the music which likes And give some water