Question: The first SELECT statement given on p.97 is copied below. SELECT InvoiceTotal, PaymentTotal, CreditTotal, InvoiceTotal - PaymentTotal - CreditTotal AS BalanceDue FROM Invoices; The BalanceDue

The first SELECT statement given on p.97 is copied below.

SELECT InvoiceTotal, PaymentTotal, CreditTotal, InvoiceTotal - PaymentTotal - CreditTotal AS BalanceDue FROM Invoices;

The BalanceDue in the output of this statement is called a derived or calculated column because it is not defined in the Invoices table but in this statement. In other words, there is no BalanceDue data can be found in the Invoices table.

Assume that, there are some invoices in the Invoices table, their PaymentTotal or CreditTotal or both have no data value for some reasons. Discuss, for these invoices, what will be the reasonable value of BalanceDue at the output of this statement and explain why.

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 Databases Questions!

Question 17 (2.5 points) The CREATE DATABASE statement creates two files on the hard drive of the server: a data file and a index file log file key file none of the above Question 18 (2.5 points) If...

SQL Question 1 When coded within a SELECT clause, which TOP clause will return a result set consisting of the ten largest InvoiceNumbers? a. TOP InvoiceNumber, InvoiceTotal b. TOP 10 InvoiceTotal c....

Code example 6 - 1 SELECT VendorName, COUNT ( * ) AS NumberOfInvoices, MAX ( InvoiceTotal - PaymentTotal - CreditTotal ) AS BalanceDue FROM Vendors JOIN Invoices ON Vendors.VendorID =...

Please help me double check my answers: For QUERIES 1-6 : What each query is requesting from the database. Include descriptions for what ALL of the following SQL keywords are doing in each query they...

SQL Please help me by filling in the 5 blanks correctly with SQL commands. Thank you! Fill in the blanks in the SQL statement below that will list the rows with an invoice_total that is greater than...

SQL Please help me in put in the correct SQL commands in the 6 blanks ______ below. Thank you in advance! Fill in the blanks in the SQL statement below that will list the invoice number, vendor...

1. Use the AP database. Write a query that returns the VendorName and VendorState from those vendors from the state of Ohio plus show the VendorName along with the words 'Outside OH' for those...

QUESTION 1 Use the AP database. Write a query that returns the VendorName and VendorState from those vendors from the state of Ohio plus show the VendorName along with the words 'Outside OH' for...

IS 2 7 6 DB MODULE 5 Correct Table Joins and Join Fields & Summary Queries USE AP Vendors to Invoices ( on VendorID ) Invoices to InvoiceLineItems ( on InvoiceID ) InvoiceLineItems to GLAccounts ( on...

CSC255 Chapter 3 Homework (You'll be creating a query for each problem. Copy and past all your queries into one text file (best to use Notepad++ for it) In these exercises, youll enter and run your...

For a chemical reaction, the rate constant at 25C is doubled when the temperature is raised to 45 C. Determine the activation energy in kJ mol-.

We discussed the role legal ethics plays in a paralegal's day-to-day conduct. In today's world, paralegals must also understand how social media impacts the legal profession. In your initial post,...

Bidding firm ( Firm B ) has 5 , 6 0 7 shares outstanding that are currently selling at $ 4 6 per share. Target firm ( Firm T ) has 1 , 8 8 6 shares outstanding that are currently selling at $ 1 7 per...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Draw on your experience at work or school. What routine or neutral messages have you sent or received in the past two weeks? Were they presented using the direct plan? (Objective 1)

Correct the following memo headings: (Objective 5) a. TO: Ebony Cartier FROM: Seth Maas Subject: Fiscal Year Closing Procedures Date: June 1, 200 c. 2008 June 09 SUBJECT: Vacation Requests TO:...

What determines whether a congratulatory business message is timely? (Objective 6)