Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Introduction to Databases and Data Warehouses

Authors: Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov

1st edition

978-1943153190, 1943153191, 978-0132575676

More Books

Students also viewed these Databases questions