Question: Write a query that will list all the customers who have never taken a charter trip. Use a subquery. Display the customer name as one

Write a query that will list all the customersWrite a query that will list all the customers

Write a query that will list all the customers who have never taken a charter trip. Use a subquery. Display the customer name as one field in the following format - last name, first name. Display the phone number as a formatted field (999)999-9999. Display the balance as currency with 2 decimal places. Customer Phone Balance Olowski, Paul (615) 894-2180 $1,290.00 O'Brian, Amy (713) 442-3381 $1,010.00 Farriss, Anne (713) 382-7185 $.00 CREATE TABLE CUSTOMER ( CUS_CODE integer PRIMARY KEY, CUS_LNAME varchar2(15), CUS_FNAME varchar2(15), CUS_INIT varchar2(1), CUS_AREA varchar2(3), CUS_PHONE varchar2(8), CUS_BALANCE float(8) ) CREATE TABLE CHARTER ( CHAR_TRIP integer PRIMARY KEY, CHAR_DATE date, AC_NUMBER varchar2(5), CHAR_DEST varchar2(3), CHAR_DISTANCE float(8), CHAR_HOURS_FLOWN float(8), CHAR_HOURS_WAIT float(8), CHAR_FUEL_GALLONS float(8), CHAR_OIL_QTS integer, CUS_CODE integer, FOREIGN KEY (AC_NUMBER) REFERENCES AIRCRAFT (AC_NUMBER), FOREIGN KEY (CUS_CODE) REFERENCES CUSTOMER (CUS_CODE) )

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 General Management Questions!