SQL Exercises: Find the minimum purchase amount of all the orders
SQL Aggregate Functions: Exercise-7 with Solution
From the following table, write a SQL query to find the minimum purchase amount.
Sample table: orders
ord_no purch_amt ord_date customer_id salesman_id ---------- ---------- ---------- ----------- ----------- 70001 150.5 2012-10-05 3005 5002 70009 270.65 2012-09-10 3001 5005 70002 65.26 2012-10-05 3002 5001 70004 110.5 2012-08-17 3009 5003 70007 948.5 2012-09-10 3005 5002 70005 2400.6 2012-07-27 3007 5001 70008 5760 2012-09-10 3002 5001 70010 1983.43 2012-10-10 3004 5006 70003 2480.4 2012-10-10 3009 5003 70012 250.45 2012-06-27 3008 5002 70011 75.29 2012-08-17 3003 5007 70013 3045.6 2012-04-25 3002 5001
Sample Solution:
-- This query retrieves the minimum value in the 'purch_amt' column from the 'orders' table.
SELECT MIN(purch_amt)
-- Specifies the table from which to retrieve the data (in this case, 'orders').
FROM orders;
Output of the Query:
min 65.26
Code Explanation:
The said SQL statement is used to retrieve the lowest value in the "purch_amt" column from the 'orders' table. The "MIN" function is used to find the minimum value in the specified column.
The result of the query would be a single value representing the lowest "purch_amt" in the 'orders' table.
Relational Algebra Expression:
![Relational Algebra Expression: Find the minimum purchase amount of all the orders.](https://www.w3resource.com/w3r_images/sql-aggregate-function-relational-algebra-7.png)
Relational Algebra Tree:
![Relational Algebra Tree: Find the minimum purchase amount of all the orders.](https://www.w3resource.com/w3r_images/sql-aggregate-function-relational-algebra-tree-diagram-7.png)
Explanation:
![Syntax of find the minimum purchase amount of all the orders](https://www.w3resource.com/w3r_images/sql-exercise-aggregate-function-code-7.gif)
Visual presentation :
![Find the minimum purchase amount of all the orders](https://www.w3resource.com/w3r_images/sql-exercise-aggregate-funtion-result-7.gif)
Practice Online
Query Visualization:
Duration:
![Query visualization of Find the minimum purchase amount of all the orders - Duration](https://www.w3resource.com/w3r_images/sql-aggregate-function-exercise-7-duration.png)
Rows:
![Query visualization of Find the minimum purchase amount of all the orders - Rows](https://www.w3resource.com/w3r_images/sql-aggregate-function-exercise-7-rows.png)
Cost:
![Query visualization of Find the minimum purchase amount of all the orders - Cost](https://www.w3resource.com/w3r_images/sql-aggregate-function-exercise-7-cost.png)
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous SQL Exercise: Find the maximum purchase amount of all the orders.
Next SQL Exercise: Highest grade for each of the cities of the customers.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics