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';