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

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 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

Explanation / Answer

Answer) The query is

SELECT LastName,FirstName,City FROM Customer WHERE city = 'FL' OR city = 'TX';

This is the proper syntax of using where clause with OR condition :

SELECT column1, column2... FROM table_name WHERE condition1 OR condition2;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.