ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 2 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 23 May 2017 My Price 9.00

Use T-SQL to create a view of the simpleco

Please help me write MS SQL scripts for the following using the attached SQL  query to create the database 

 

Use T-SQL to create a view of the simpleco customer and invoice tables.  the view should select for the customer number, customer last name, customer balance, invoice number, invoice date, and invoice amount.  Name the view v_cust_invoices.

 

When the view has been created, write a T-SQL query to execute the v_cust_invoices view to display all columns selected by the view.

 

Using the v_cust_invoices view, write a T-SQL query to display the sum of the customer balances, rounded to two decimals with a column name of SumCustBal, and the sum of the invoice amounts, rounded to two decimals with a column name of SumCustInvoices.

 

Using the v_cust_invoices view, write a T-SQL alter view query to change the default date format for inv_date from YYYY-MM-DD 00:00:00.000 to MM-DD-YY format, for example:  03-23-2010 instead of 2010-03-23 00:00:00.000.

 

Repeat the select all query on the v_cust_invoices view to verify that you alter view query changed the formatting of the inv_date.

CREATE TABLE CUSTOMER (CUST_NUM int,CUST_LNAME varchar(20),CUST_FNAME varchar(20),CUST_BALANCE float(8));INSERT INTO CUSTOMER VALUES('1000','Smith','Jeanne','1050.11');INSERT INTO CUSTOMER VALUES('1001','Ortega','Juan','840.92');/* -- */CREATE TABLE CUSTOMER_2 (CUST_NUM int,CUST_LNAME varchar(20),CUST_FNAME varchar(20));INSERT INTO CUSTOMER_2 VALUES('2000','McPherson','Anne');INSERT INTO CUSTOMER_2 VALUES('2001','Ortega','Juan');INSERT INTO CUSTOMER_2 VALUES('2002','Kowalski','Jan');INSERT INTO CUSTOMER_2 VALUES('2003','Chen','George');/* -- */CREATE TABLE INVOICE (INV_NUM int,CUST_NUM int,INV_DATE datetime,INV_AMOUNT float(8));INSERT INTO INVOICE VALUES('8000','1000','3/23/2010','235.89');INSERT INTO INVOICE VALUES('8001','1001','3/23/2010','312.82');INSERT INTO INVOICE VALUES('8002','1001','3/30/2010','528.10');INSERT INTO INVOICE VALUES('8003','1000','4/12/2010','194.78');INSERT INTO INVOICE VALUES('8004','1000','4/23/2010','619.44');
 
 

Attachments:

Answers

ComputerScienceExpert
(11)
Status NEW Posted 23 May 2017 08:05 AM My Price 9.00

-----------

Attachments

file 1495527275-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------
Not Rated(0)