**Functions** | Description |

max | We can find out maximum value from a field of mysql table by using max command |

min | Minimum value among records can be found out by using min sql command |

sum | Our query can return sum of numeric data present in a record |

avg | We can get the average value of a range of data by using avg function. |

floor | Math floor function to get highest integer value. |

ceil | Math ceil function to get lowest integer value. |

count | Counting the number of records in a table with conditions |

Mod | Getting the reminder of a division and using in our Query |

Second highest | WE can display first and second highest number present in table by using limit and order by commands |

Data format | Getting the formatted output from mysql table by using format query. |

sqrt | Square root of number |

pow | Power of a number & creating a square table |