• 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