Answered step by step
Verified Expert Solution
Question
1 Approved Answer
List the first name, last name, city and state of all customers who ordered either a bike or a car rack. [Hint: Eliminate duplicates using
List the first name, last name, city and state of all customers who ordered either a bike or a car rack. [Hint: Eliminate duplicates using the DISTINCT keyword] (27 rows expected)
Vendors VendorID INT Vend Name VARCHAR(25) VendStreetAddress V ARCHAR(50) Vend Gity V ARCHAR(30) Vend State VARCHAR(2) VendZipCode V ARCHAR(10) VendPhoneNumber VAROHAR(15) VendFaxNumber VARCHAR(15) VendWebPage TEXT VendEMailAddress VAROHAR(50) Indexes Categories CategoryID INT CategoryDescription VAROHAR(75) indexes Customers P VendorID INT ProductNum ber INT ProductName VAROHAR(50) ProductDescription VARCHAR(100) RetailPrice DECIMAL (15,2) QuantityOnHand SMALLINT CategoryID INT IndexesStep by Step Solution
There are 3 Steps involved in it
Step: 1
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