Min, Max Functions Example
This example returns the lowest and highest sale for orders shipped to the United Kingdom.
SELECT Min([Order Amount]) FROM Orders WHERE [Ship Country] = 'UK';
SELECT Max([Order Amount]) FROM Orders WHERE [Ship Country] = 'UK';