Ask question

Ask question

All categories

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

The _________ check is a type of hardware control that involves adding a "1" or a "0" to the end of every 8 bit byte such that t

stira [4]

Answer:

The correct answer to the following question is an option (b) parity.

Explanation:

Because it is a bit that appends to the binary bit and it has the sets of one or either zero by which a total number of the one bits is the odd or the even parity bit.

Parity bit is a type of bit by which we can check when the data is moved to another place than at that time the data is written over or lost and also we check data at that time when these data is transmitted from one computer to other computers.

7 0

3 years ago

Drag each statement to the correct location.

VMariaS [17]

Answer:

$(a)\ 222_{10} = DE_{16}$ --- True

$(b)\ D7_{16} = 11010011_2$ --- False

$(c)\ 13_{16} = 19_{10}$ --- True

Explanation:

Required

Determine if the statements are true or not.

$(a)\ 222_{10} = DE_{16}$

To do this, we convert DE from base 16 to base 10 using product rule.

So, we have:

$DE_{16} = D * 16^1 + E * 16^0$

In hexadecimal.

$D =13 \\E = 14$

So, we have:

$DE_{16} = 13 * 16^1 + 14 * 16^0$

$DE_{16} = 222_{10}$

Hence:

(a) is true

$(b)\ D7_{16} = 11010011_2$

First, convert D7 to base 10 using product rule

$D7_{16} = D * 16^1 + 7 * 16^0$

$D = 13$

So, we have:

$D7_{16} = 13 * 16^1 + 7 * 16^0$

$D7_{16} = 215_{10}$

Next convert 215 to base 2, using division rule

$215 / 2 = 107 R 1$

$107/2 =53 R 1$

$53/2 =26 R1$

$26/2 = 13 R 0$

$13/2 = 6 R 1$

$6/2 = 3 R 0$

$3/2 = 1 R 1$

$1/2 = 0 R1$

Write the remainders from bottom to top.

$D7_{16} = 11010111_2$

<em>Hence (b) is false</em>

$(c)\ 13_{16} = 19_{10}$

Convert 13 to base 10 using product rule

$13_{16} = 1 * 16^1 + 3 * 16^0$

$13_{16} = 19$

Hence; (c) is true

7 0

2 years ago

The Internet was first used by which of the following institutions?

Phantasy [73]

Answer:

U.S Department of Defense

Explanation:

(btw nazi party was around before the internet and ended before the internet therefor couldn't be that)

5 0

3 years ago

True or false a mirrorless camera has a pentaprism

inessss [21]

Answer:

No the pentaprism or pentamirror are both optical viewfinder viewing systems and are not part of the mirrorless camera. Some thing the pentaprism actually operates better than the electronic viewfinder of mirrorless cameras.

Explanation:

7 0

2 years ago

Read 2 more answers

Write a Python program to solve the problem described above. Define a function satisfactory_meal(Meal) which takes a single para

kompoz [17]

def dx(fn, x, delta=0.001):

return (fn(x+delta) - fn(x))/delta

def solve(fn, value, x=0.5, maxtries=1000, maxerr=0.00001):

for tries in xrange(maxtries):

err = fn(x) - value

if abs(err) < maxerr:

return x

slope = dx(fn, x)

x -= err/slope

raise ValueError('no solution found')

3 0

2 years ago