Types of functions and number functions

- [Instructor] Let's understand the types of functions that we can apply on rows in tables. Before that, let's understand what a function is. A function performs a specific action. It takes some arguments as input and always returns a value as output. They can perform different kinds of actions like calculations, manipulating the output rows as per the requirement, working with dates, converting data types and many more. Functions are broadly categorized into two types: single row and multiple row functions. The main difference between single row and multiple row functions is that single row functions work on one row at a time and returns one result for every row. While multiple row functions work on a group of rows and return one result for every group. Now let's look at all the single row functions. Number functions perform various arithmetic operations or calculations on the data. Character functions work with…