32. Complete and print your statements and results by spooling your file (with e

Question

32.          Complete and print your statements and results by spooling your file (with echo on from Oracle if available).

List the customer ID, first name, and last name of all customers whose first or last names start with the letter ‘W.’ Sort by last name and use the following column headings: Customer_ID, First_Name, Last_Name.

ResDetail Customer CustlD CustFName CustLName CustPhone CustType LoyaltylD Reservation ResID CheckinDate CheckOutDate CustID AgentID ReslD Room CustType CustType CustTypeDesc RoomNum RateType RateAmt RoomType Agent AgentlD AgentFName AgentLName AgentType RateType RateType RateTypeDesc RoomType RoomType RoomTypeDesc AgentType AgentType AgentTypeDesc

Explanation / Answer

SET ECHO ON

SELECT CustID AS Customer_ID, CustFName AS First_Name, CustLName AS Last_Name FROM Customer WHERE CustFName LIKE 'W%' OR CustLName LIKE 'W%' ORDER BY CustLName;

EXIT

**Comment for any further queries.

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

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