Learning Goal: I’m working on a mysql question and need an explanation and answer to help me learn.If you have not already done so, use MSSQLS Management Studio to create a new database named ch08_simpleco. Use the default settings. When the database has been created, run the Ch08_SimpleCo_SQL.sql script to create and load the database tables and data. 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 your alter view query changed the formatting of the inv_date. Once you have completed your assignment, copy and paste the script into a Word document and submit it.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now