How do you use numeric functions with an example?

MySQL provides several numeric functions that allow you to perform various mathematical operations on number values. These functions include operations like rounding numbers, finding maximum and minimum values, and performing mathematical calculations. Below is an example of how to use some of these numeric functions in MySQL.


        // Example of using numeric functions in MySQL
        $query = "SELECT 
                      ROUND(price, 2) AS rounded_price,
                      CEIL(discount) AS ceiling_discount,
                      FLOOR(rating) AS floor_rating,
                      MAX(sales) AS max_sales,
                      MIN(sales) AS min_sales
                  FROM products;";