Question 1 of 30
In a retail database, a manager wants to identify which products have generated total sales exceeding $10,000 over the last quarter. The manager runs a query that groups sales by product and calculates the total sales for each product. Which clause should the manager use to filter the results to only include products with total sales above this threshold?
HAVING total_sales > 10000
WHERE total_sales > 10000
GROUP BY total_sales > 10000
FILTER total_sales > 10000

Preparing for Oracle Database SQL? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free