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 Member_Number FROM Member_Dimension INNER JOIN Item_Scan_Fact ON Member_Dimension .Member_Key = Item_Scan_Fact .Member_Key INNER JOIN Store_Dimension ON Item_Scan_Fact.Store_Key= Store_Dimension.Store_Key COUTN(Store_Number)>= 2 AND Year = '2000'

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.