Group Filtering with HAVING

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Group Filtering with HAVING. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

NetSuite QA analysts need to identify customers with multiple approved sales orders. Using the netsuite_sales_orders table, write a PostgreSQL query that groups orders by customer and filters groups using an aggregate condition.

Requirements

Include only rows where status is Approved.
Return customers with at least two approved sales orders, along with the approved order count, ordered from the largest count to the smallest.

Schema

netsuite_sales_orders

Column	Type	Description
order_idPK	INT	Unique sales order identifier
customer_name	VARCHAR(100)	NetSuite customer name
status	VARCHAR(20)	Sales order approval status
order_amount	DECIMAL(10,2)	Sales order amount
order_date	DATE	Date the order was created

Tablesnetsuite_sales_orders

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results