W3. SQL Min and Max

Question 1

Q: What does the SQL MIN() function do?

Answer 1

A: Returns the smallest value in a selected column.

Question 2

Q: What does the SQL MAX() function do?

Answer 2

A: Returns the largest value in a selected column.

Question 3

Q: Write a query to find the lowest price in the “Price” column of the “Products” table.

Answer 3

SELECT MIN(Price) 
FROM Products;

Question 4

Q: Write a query to find the highest price in the “Price” column of the “Products” table.

Answer 4

SELECT MAX(Price) 
FROM Products;

Question 5

Q: What is the syntax for using MIN() or MAX() with a condition?

Answer 5

SELECT MIN(column_name) 
FROM table_name 
WHERE condition;

Question 6

Q: How can you give a descriptive name to the result column of MIN() or MAX()?

Answer 6

A: Use the AS keyword to set an alias, e.g.,
SELECT MIN(Price) AS SmallestPrice.

Question 7

Q: Write a query to find the smallest price in the “Products” table and label it as “SmallestPrice.”

Answer 7

SELECT MIN(Price) AS SmallestPrice 
FROM Products;

Question 8

Q: How do you use MIN() with GROUP BY to return the smallest price for each category?

Answer 8

SELECT MIN(Price) AS SmallestPrice, CategoryID 
FROM Products 
GROUP BY CategoryID;