Complete and print the following SQL transactions. Log your statements and resul

Question

Complete and print the following SQL transactions. Log your statements and results by spooling your file (with echo on from Oracle if available).

List the customer ID, first name, and last name for all customers for whom no phone number exists. Sort the output by customer ID.

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

Answer:

select CustID,CustFName,CustLName from Customer where CustPhone is NULL order by CustID;

/*This query will list down the Customer ID, First Name and Last Name of the customer who dont have Phone Number*/

Output:

CustID CustFName CustLName 1234 Andy Balbirne 1235 Andrew Symonds 1245 Mitchell Starc

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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