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)

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
Get step-by-step solutions from verified subject matter experts
