Question

Find the maximum and minimum commission from the SALE table.

Answer 1

SELECT MAX(Commission) AS Maximum_Commission,
       MIN(Commission) AS Minimum_Commission
FROM SALE;

• MAX(Commission): Finds the highest commission value in the table.
• MIN(Commission): Finds the lowest commission value in the table.