Question: Write a query to display the, last name, first name and city for every customer in Florida (use FL) or Texas (use TX) Florida (use

Write a query to display the, last name, first name and city for every customer in Florida (use FL) or Texas (use TX)

Write a query to display the, last name, first name and city

Florida (use FL) or Texas (use TX) SalesRep PK ReplD int Customer varchar(20) varchar(20) PK CustomerlD int O--OLastName FirstName CommissionRatedecimal (10,2) LastName varchar(20) FirstName varchar(20) Street City State Zipcode char(5) Balance decimal(10,2) varchar(20) varchar(20) char(2) Order FK1 ReplD int FK1 CustomerlD int OrderDate date ShipDate date Part PK PartID int OrderLine Description varhar(20) UnitsOnHand int ItemClass char(4) Retail Cost PK,FK1 OrderlD int decimal(10,2) decimal(10,2) Quantityint

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!