Date_Dimension Date_Key Date Description Day OF Week Day Description Weekday Fla

Question

Date_Dimension Date_Key Date Description Day OF Week Day Description Weekday Flag Day OF Month Day OF_Year Month _Descrip... Month Of Year Quarter Descr... v Time_Dimensi... Item_Dimension (dbo. Time_Key ?Item_Key Time Description AM PM Item Number Category_Number Sub_Category_Number Primary_Description Secondary_Description Color Description Size_Description Item Status Code Fineline Item_Scan_ Fact (dbo.Item... Visit Number Store_Key Item Key Member_Key Transaction_Type Key Transaction_Date Key Transaction Store Time Kev TransactionBase_Time_ Key Item Quantity Total_Scan Amount Member_Dimension (d Member_Key Member_Number Zip_Code Member_Type Member_Status_Code Elite_Status_Code Bus_CR_Type Code Secondary Card Count Qualify_Org Code Complimentary Card_... Scan_Type_Dimensiond 7 Transaction_Type_Key Transaction_Type_Code Store Dimension.. StoreKey Store Number Store Name Subdivision N... Region_Number District Number Open Date_Key Store_Type Street_Address City

Explanation / Answer

As many fields are not visible in the given screenshot, based on the given data I assume table Store_Dimension also contains the state of the store.

Below query will be used to find the number of stores by state. Aggregate funtion COUNT() is used to get the number of stores, group by state is used to group the result by State.

Query-

SELECT State, COUNT(Store_Number)

FROM Store_Dimension

GROUP BY State;

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.