All categories

3 years ago

Write a SELECT statement that returns these four columns:

Computers and Technology

1 answer:

tatuchka [14]3 years ago

5 0

Answer:

SELECT vendor_name, invoice_number, invoice_date,

(invoice_total - payment_total - credit_total) AS balance_due

FROM vendors AS v JOIN invoices AS i

ON vendors.vendor_id = Invoices.vendor_id

WHERE invoice_total - payment_total - credit_total > 0

ORDER BY vendor_name;

Explanation:

The query statement returns joint records of vendor name, invoice number, invoice date, and balance due from the vendor and invoice tables represented with aliases v and i respectively.

It returns an output with the WHERE clause condition to only return balance due greater than zero and the output is returned in ascending order of the vendor's names.

You might be interested in

Every file on a storage device has a _______. (a.) name (b.) size (c.)both of the above (d.) none of the above

zmey [24]

The correct answer is: C: both of the above, i. e. name and size.

8 0

3 years ago

Define and use in your program the following functions to make your code more modular: convert_str_to_numeric_list - takes an in

Lelechka [254]

Answer:

In Python:

def convert_str_to_numeric_list(teststr):

nums = []

res = teststr.split()

for x in res:

if x.isdecimal():

nums.append(int(x))

else:

nums = []

break;

return nums

def get_avg(mylist):

if not len(mylist) == 0:

total = 0

for i in mylist:

total+=i

ave = total/len(mylist)

else:

ave = "None"

return ave

def get_min(mylist):

if not len(mylist) == 0:

minm = min(mylist)

else:

minm = "None"

return minm

def get_max(mylist):

if not len(mylist) == 0:

maxm = max(mylist)

else:

maxm = "None"

return maxm

mystr = input("Enter a string: ")

mylist = convert_str_to_numeric_list(mystr)

print("List: "+str(mylist))

print("Average: "+str(get_avg(mylist)))

print("Minimum: "+str(get_min(mylist)))

print("Maximum: "+str(get_max(mylist)))

Explanation:

<em>See attachment for complete program where I use comment for line by line explanation</em>

Download txt

7 0

3 years ago

tino4ka555 [31]

<span>This is called an unshielded twisted pair cable, which is also known as a UTP cable. This type of cable has four pairs of wires that are twisted around each other. Because the wires are like this, the electrical interference is reduced.</span>

3 0

4 years ago

Technician A says that using 100% coolant is better for freeze protection in an engine than a mixture with water. Technician B s

Levart [38]

Answer:

Technician B is right.

Explanation:

Generally speaking, most engines use a mixture of 50/50 coolant and water.

This is ideal in places where the weather never gets too extreme, and temperatures rarely go below 0 degrees. Using 100% antifreeze or coolant in any engine is not recommended since this doesn't have the same ability as water to transfer heat to or from the engine. Antifreeze is used to lower the freezing point of water, and it is water itself that does the job of keeping engine temperatures safe.

4 0

3 years ago

Many application controls are useful for enhancing the reliability of both transaction data and master record data. This applica

Rzqust [24]

Answer:

True

Explanation:

In most accounting software like SAP, Application control performs what is known as validity check.

And Validity check is when this application control compares the data entered into a field for a transaction to that in a master record to verify the data entered exists.

With above definition we can infer that the question statement is true.

5 0

3 years ago