What are some of the more common SQL functions?

What are some of the more common SQL functions?How would you use them to generate

useful information for your organization?