MySQL: Functions

• If you want want to create a custom column which will hold the upper case letters and everything then use the character function UPPER -
  SELECT name, UPPER(name) FROM customers
• There are different kinds of function in MySQL like UPPER, one of them is SQRT which is numeric function -
  SELECT cost, SQRT(cost) FROM items
• Use AVG function to find out average of your data -
  SELECT cost, AVG(cost) FROM items
• Use SUM function to sum your data -
  SELECT SUM(bids) FROM items

Notice:

1. UPPER function is used to generate upper values or characters.
2. SQRT-Square root, AVG-Average, SUM-Summation are numeric functions who are used to calculate desired informations/data.