[Solved] What will be the result of this query on a star schema?SELECT d.StoreName, COUNT(*) AS SalesCount FROM Sales f INNER JOIN Store d ON f.StoreID = d.StoreID GROUP BY d.StoreName HAVING COUNT(*) > 100; | SQL

SQL - Database Design and Normalization

What will be the result of this query on a star schema?

SELECT d.StoreName, COUNT(*) AS SalesCount FROM Sales f INNER JOIN Store d ON f.StoreID = d.StoreID GROUP BY d.StoreName HAVING COUNT(*) > 100;

AAll stores with their total sales amount

BList of sales records without grouping

CStores with less than 100 sales records

DStores with more than 100 sales records and their sales count

Step-by-Step Solution

Solution:

Step 1: Understand JOIN and GROUP BY
The query joins Sales and Store tables, grouping by store name.
Step 2: Interpret HAVING clause
HAVING filters groups with sales count greater than 100.
Final Answer:
Stores with more than 100 sales records and their sales count -> Option D
Quick Check:
HAVING filters grouped results > 100 [OK]

Quick Trick: Use HAVING to filter groups after aggregation [OK]

Common Mistakes:

Master "Database Design and Normalization" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the result of this query on a star schema?