﻿ SQL Aggregate Function: Find higher purchase amount of customers within a specific range - w3resource

# SQL Exercises: Find higher purchase amount of customers within a specific range

## SQL Aggregate Functions: Exercise-13 with Solution

Write a SQL statement to find the highest purchase amount with their ID and order date, for those customers who have a higher purchase amount in a day is within the range 2000 and 6000.

Sample table: orders

Sample Solution:

``````SELECT customer_id,ord_date,MAX(purch_amt)
FROM orders
GROUP BY customer_id,ord_date
HAVING MAX(purch_amt) BETWEEN 2000 AND 6000;
``````

Output of the Query:

```customer_id	ord_date	max
3007		2012-07-27	2400.60
3002		2012-09-10	5760.00
3009		2012-10-10	2480.40
3002		2012-04-25	3045.60
```

Explanation:

Pictorial presentation:

## Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?

﻿