Question:

Using the ch08_saleco database write a T-SQL query to display the customer code and customer last name from the customer table where a record is returned from the invoice table where the customer customer code equals the invoice customer code.  (hint:  exists)

 

Using the ch08_saleco database write a T-SQL query to display the customer code, customer last name, and customer phone for phone numbers begin with the prefix 894.

 

Using the ch08_saleco database write a T-SQL query to display the customer code, invoice number invoice date, and invoice subtotal from invoice conditioned on the invoice subtotal is greater than $100 and from only customer codes 10011 and 10012.  (hint:  in)

 

 

 

/* Database Systems, 8th Ed., Rob/Coronel *//* Type of SQL : SQL Server */CREATE TABLE CUSTOMER (CUS_CODE int,CUS_LNAME varchar(15),CUS_FNAME varchar(15),CUS_INITIAL varchar(1),CUS_AREACODE varchar(3),CUS_PHONE varchar(8),CUS_BALANCE float(8));INSERT INTO CUSTOMER VALUES('10010','Ramas','Alfred','A','615','844-2573','0');INSERT INTO CUSTOMER VALUES('10011','Dunne','Leona','K','713','894-1238','0');INSERT INTO CUSTOMER VALUES('10012','Smith','Kathy','W','615','894-2285','345.86');INSERT INTO CUSTOMER VALUES('10013','Olowski','Paul','F','615','894-2180','536.75');INSERT INTO CUSTOMER VALUES('10014','Orlando','Myron','','615','222-1672','0');INSERT INTO CUSTOMER VALUES('10015','O''Brian','Amy','B','713','442-3381','0');INSERT INTO CUSTOMER VALUES('10016','Brown','James','G','615','297-1228','221.19');INSERT INTO CUSTOMER VALUES('10017','Williams','George','','615','290-2556','768.93');INSERT INTO CUSTOMER VALUES('10018','Farriss','Anne','G','713','382-7185','216.55');INSERT INTO CUSTOMER VALUES('10019','Smith','Olette','K','615','297-3809','0');/* -- */CREATE TABLE INVOICE (INV_NUMBER int,CUS_CODE int,INV_DATE datetime,INV_SUBTOTAL float(8),INV_TAX float(8),INV_TOTAL float(8));INSERT INTO INVOICEVALUES('1001','10014','1/16/2010','24.90','1.99','26.89');INSERT INTO INVOICEVALUES('1002','10011','1/16/2010','9.98','0.80','10.78');INSERT INTO INVOICEVALUES('1003','10012','1/16/2010','153.85','12.31','166.16');INSERT INTO INVOICEVALUES('1004','10011','1/17/2010','34.97','2.80','37.77');INSERT INTO INVOICEVALUES('1005','10018','1/17/2010','70.44','5.64','76.08');

• 1495678998-Ch08_SaleCo_SQL_txt 1.docx

ComputerScienceExpert

(11)

Status NEW Posted 25 May 2017 02:05 AM My Price 9.00

Ans-----------wer----------- Fi-----------le-----------

Attachments

file 1602983411-Answer File.docx preview (28 words )

A-----------NS------------1 -----------sel-----------ect----------- CU-----------STO-----------MER-----------.CU-----------S_C-----------ODE-----------,CU-----------STO-----------MER-----------.CU-----------S_L-----------NAM-----------E f-----------rom----------- CU-----------STO-----------MER----------- in-----------ner----------- jo-----------in -----------INV-----------OIC-----------E o-----------n C-----------UST-----------OME-----------R.C-----------US_-----------COD-----------E=I-----------NVO-----------ICE-----------.CU-----------S_C-----------ODE----------- A-----------NS------------2 -----------SEL-----------ECT----------- CU-----------STO-----------MER-----------.CU-----------S_C-----------ODE-----------,CU-----------STO-----------MER-----------.CU-----------S_L-----------NAM-----------E,C-----------UST-----------OME-----------R.C-----------US_-----------PHO-----------NE -----------FRO-----------M C-----------UST-----------OME-----------R W-----------HER-----------ECU-----------S_P-----------HON-----------E L-----------IKE----------- '8-----------94%-----------' -----------ANS----------- -3----------- S-----------ELE-----------CT -----------CUS-----------_CO-----------DE,----------- IN-----------V_N-----------UMB-----------ER -----------INV-----------_DA-----------TE,----------- IN-----------V_S-----------UBT-----------OTA-----------L F-----------ROM----------- IN-----------VOI-----------CE -----------WHE-----------RE -----------INV-----------_SU-----------BTO-----------TAL-----------&am-----------p;g-----------t;1-----------00 -----------AND----------- CU-----------S_C-----------ODE----------- IN----------- (1-----------001-----------1,1-----------001-----------2) ----------- -----------

Not Rated(0)

• Buy Answer