If we have to find out the minimum value from a given column then we have to use the function MIN. The basic structure of this function is given below;
In case, we have to know the least amount of sales then we will perform the following function,
Boston $1300 Jan-05-2011
San Diego $350 Jan-07-2011
Los Angeles $400 Jan-08-2011
Boston $800 Jan-08-2011
The syntax is given below,
$350 shows the lowest amount from the given values in sales column. These values are $1300, $350, $400, and $800.