Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedList 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 Indexes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

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

Upgrading Oracle Databases Oracle Database New Features

Authors: Charles Kim, Gary Gordhamer, Sean Scott

1st Edition

B0BL12WFP6, 979-8359657501

More Books

Students also viewed these Databases questions

Question

Employ effective vocal cues Employ effective visual cues

Answered: 1 week ago