Answers for "select max min sql"

sql select max where

SELECT MAX(salary), MIN(salary) FROM employees WHERE genre = 'MALE';

sql select min

-- This gives you the customer name and balance for
-- the customer with the lowest balance.

select CustomerName, Balance -- start your query as normal
from Customers
where Balance = ( -- now when specifying where, you do another query
  select MIN(Balance) -- where you select the lowest balance
  from Customers
);