1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Levart [38]
3 years ago
13

Write a SELECT statement that returns four columns from the Invoices table, named Number, Total, Credits, and Balance: Number Co

lumn alias for the InvoiceNumber column Total Column alias for the InvoiceTotal column Credits Sum of the PaymentTotal and CreditTotal columns Balance InvoiceTotal minus the sum of PaymentTotal and CreditTotal Use the AS keyword to assign column aliases.
Computers and Technology
1 answer:
AleksAgata [21]3 years ago
7 0

Answer and Explanation:

For returning four columns from the  Invoices table, named Number, Total, Credits, and Balance the SELECt statement is as follows

Select     Invoice Number     As     Number

              Invoice Total          As      Total

Payment total + credit total  As      Credits

Invoice total

(Payment total + credit total) As     Balance

These are displayed as above

You might be interested in
How to cite a dictionary in mla 8 owl perdue?
Elan Coil [88]
<span>To cite an entry in a dictionary according to Purdue Owl MLA 8th generation, you would cite it as any other book but do not include the publisher or the volume (if arranged alphabetically. An example is: "Creation" The American Heritage Dictionary. 3rd ed., 1997.</span>
6 0
3 years ago
Any BTS army here
kirill115 [55]
I am bts army unite

5 0
3 years ago
Read 2 more answers
// GetData() method accepts order number and quantity // that are used in the Main() method // Price is $3.99 each using System;
Amiraneli [1.4K]

Answer:

The method definition to this question as follows:

Method definition:

//method GetData

       public static void GetData(out int order, out int amount)//defining method GetData  

       {  

           String val1, val2;  //defining String variable

           Write("Enter order number ");  //message

           val1 = ReadLine();  //input value by user

           Write("Enter quantity ");  //message

           val2 = ReadLine();  //input value by user

           order = Convert.ToInt32(val1);  //convert value in integer and hold in order variable  

           amount = Convert.ToInt32(val2);  //convert value in integer and hold in amount variable

       }

Explanation:

In the above C# method definition code a method  GetData() is defined in which the GetData() method is a static method, in this method parameter two integer argument "order and amount" is passed, inside a method, two string variable "val1 and val2" is declared that is used to take input by the user and convert the value into integer and store this value in the function parameter variable.

8 0
3 years ago
Help me with this two questions please
AnnyKZ [126]

Answer:

1 is def... don't know about the other one though sorry

6 0
2 years ago
Jane wishes to forward X-Windows traffic to a remote host as well as POP3 traffic. She is worried that adversaries might be moni
chubhunter [2.5K]

Answer:

She can the following tool to protect the link:

Secure Socket Shell

Explanation:

Secure Socket Shell:

It is also known as secure shell and has short form SSH. A method that is used to secure the communication over the unprotected network. This network protocol was introduced in 1995 and its most common use include the managing of different systems as the network administrator can execute different commands remotely.

In our question, Jane can use Secure socket shell in order to communicate the information to the remote end without being monitored by the adversaries.

8 0
4 years ago
Other questions:
  • Which of the following sentences is written in the active voice
    12·2 answers
  • In order for an IT security framework to meet information assurance needs, the framework needs to include policies for several a
    13·1 answer
  • What’s the best description of an opportunity cost
    5·1 answer
  • If classes C1 and C2 both implement an interface Cint, which has a method whichIsIt, and if C1 c = new C1( ); is performed at on
    15·1 answer
  • 10.
    13·1 answer
  • A measuring cylinder is used to measure the volume of an irregular<br>solid object.​
    5·1 answer
  • HELP!!!!!
    7·1 answer
  • +<br>ii) MnO4 + H2S + H+​
    9·1 answer
  • Can you see the processing step yes or no
    8·2 answers
  • Use the round function to modify the program to display at most two digits of precision in the output number.
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!