Question

SQL: Write a query to, by store (number), list the maximum number of store visits made by a customer.

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

Answer 1

Select Store_Number,max(count(Visit_Number)) from Store_Dimension inner join Item_Scan_Fact on Store_Dimension.Store_Key = Item_Scan_Fact.Store_Key group by Store_Number ;

For each Store_Number , the total count or maximum visits made by Customer(Member_Key) is displayed

Do ask if any doubt. Please upvote.