Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Display the TID, CustomerName, and TDate for sales transactions involving a customer buying a product whose ProductName is Easy Boot: REGION PRODUCT VENDOR RegionID RegionName
Display the TID, CustomerName, and TDate for sales transactions involving a customer buying a product whose ProductName is Easy Boot:
REGION PRODUCT VENDOR RegionID RegionName ProductID ProductName ProductPrice VendorID CategoryID VendorID VendorName C Chicagoland 1X1 Zzz Bag $100 PG CP PG Pacifica Gear T Tristate 2X2 Easy Boot $70 MK FW MK Mountain King 3X3 Cosy Sock $15 MK FW STORE 4X4 Dura Boot $90 PG FW CATEGORY StorelD StoreZip RegionID 5X5 Tiny Tent $150 MK CP CategoryID CategoryName S1 60600 C 6X6 Biggy Tent $250 MK CP CP Camping S2 60605 C FW Footwear S3 35400 T SOLDVIA CUSTOMER SALES TRANSACTION ProductID TID NoOfitems CustomerID CustomerName CustomerZip TID CustomerID StorelD TDate 1X1 T111 1 1-2-333 Tina 60137 T111 1-2-333 S1 2X2 T222 1 2-3-444 Tony 60611 3X3 T333 5 3-4-555 Pam 35401 T222 2-3-444 T333 1-2-333 T444 3-4-555 S2 S3 S3 1X1 T333 1 4X4 T444 1 T555 2-3-444 S3 2X2 T444 2 4X4 T555 4 5X5 T555 2 6X6 T555 1 1-Jan-2013 1-Jan-2013 2-Jan-2013 2-Jan-2013 2-Jan-2013
Step by Step Solution
★★★★★
3.43 Rating (159 Votes )
There are 3 Steps involved in it
Step: 1
Solution is provided in terms of TSQL SELECT STTID C...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started