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

Solution:

Query:

SELECT TOP 5 Member_Key FROM Member_Dimension INNER JOIN Item_Scan_Fact ON Member_Dimension .Member_Key = Item_Scan_Fact .Member_Key  WHERE Day_Description = 'Martin Luther King Day' AND Year = '2000' ORDER BY Total_Scan_Amount DESC

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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