What SQL functions are you most comfortable using, and can you provide examples of their applications?