
SQL Exercises: Find the minimum purchase amount of all the orders
SQL Aggregate Functions: Exercise-7 with Solution
Write a SQL statement to know the minimum purchase amount of all the orders.
Sample table: orders
Sample Solution:
SELECT MIN(purch_amt)
FROM orders;
Output of the Query:
min 65.26
Explanation:

Pictorial presentation :

Query Visualization:
Duration:

Rows:

Cost:

Practice Online
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL statement to know the maximum purchase amount of all the orders.
Next: Write a SQL statement which selects the highest grade for each of the cities of the customers.
What is the difficulty level of this exercise?
New Content: Composer: Dependency manager for PHP, R Programming