All categories

3 years ago

Consider the following code example:

Computers and Technology

1 answer:

yKpoI14uk [10]3 years ago

7 0

Answer:

The number of invoices for each vendor that have a larger balance due than the average balance due for all invoices.

Explanation:

This part of the code below

WHERE InvoiceTotal - PaymentTotal - CreditTotal >

(SELECT AVG (InvoiceTotal - PaymentTotal- CreditTotal)

FROM Invoices)

gives the condition to pick the invoices with balance that are greater than the average balance for all invoice.

This part of the code below

GROUP BY VendorName

ORDER BY BalanceDue DESC;

then enables the program to group the result of the above condition by VendorName and sort the resulting rows in the order of BalanceDue. You will therefore, obtain for each row in the NumberOfInvoices column, the number of invoices for each vendor that have a larger balance due than the average balance due for all invoices.

You might be interested in

Expain the application areas of ICT in education sector and E-commerce

miss Akunina [59]

Explanation:

Nowadays almost all the school and college use computers in classrooms and labs to teach students.A teacher can teach effectively using computer-based presentations.Students can study different subjects and complete their assignment by using different software in computer.The Computer Based Training(CBT) and Web Based Training(WBT) are aid to teach the student in the classroom.

E-commerce is a financial business transaction conducted electronically between business partners over the internet.Business transactions can occur very quickly and globally.The people can buy,sell and exchange the products or services using internet.Todays many computer can also access the Internet through wireless technologies.

8 0

2 years ago

Speech on inventors and inventions

vlada-n [284]

Interntors present an interesting kind of people who think in peculiar ways sometimes. This ability allows them to view certain situations in ways in which other people cannot. Because of this, they can think of new ways of how such situations can be tackled. This is how inventions are born. A person with an inventive mind sees a new situation where he thinks of a new solution how he could improve this situation with his invention.

This process is continued continuously with new generations of inventors seeing and coming back to old situations over and over again, inventing new things along the way.

4 0

3 years ago

CS160 Computer Science I In class Lab 10

lianna [129]

Answer:

The program in Python is as follows:

fname = input("Enter the translation file name: ")

with open(fname) as file_in:

lines = []

for line in file_in:

lines.append(line.rstrip('\n'))

myDict = {}

for i in range(len(lines)):

x = lines[i].split(":")

myDict[x[0].lower()] = x[1].lower()

print("Enter an English word to receive the Spanish translation.\nPress ENTER to quit.")

word = input("Enter an English word: ")

while(True):

if not word:

break

if word.lower() in myDict:

print("The Spanish word is ",myDict[word.lower()])

else:

print("I don’t have that word in my list.")

word = input("Enter an English word: ")

Explanation:

This prompts the user for file name

fname = input("Enter the translation file name: ")

This opens the file for read operation

with open(fname) as file_in:

This creates an empty list

lines = []

This reads through the lines of the file

for line in file_in:

This appends each line as an element of the list

lines.append(line.rstrip('\n'))

This creates an empty dictionaty

myDict = {}

This iterates through the list

for i in range(len(lines)):

This splits each list element by :

x = lines[i].split(":")

This populates the dictionary with the list elements

myDict[x[0].lower()] = x[1].lower()

This prints an instruction on how to use the program

print("Enter an English word to receive the Spanish translation.\nPress ENTER to quit.")

This prompts the user for an English word

word = input("Enter an English word: ")

This loop is repeated until the user presses the ENTER key

while(True):

If user presses the ENTER key

if not word:

The loop is exited

break

If otherwise, this checks if the word exists in the dictionary

if word.lower() in myDict:

If yes, this prints the Spanish translation

print("The Spanish word is ",myDict[word.lower()])

If otherwise,

else:

Print word does not exist

print("I don’t have that word in my list.")

Prompt the user for another word

word = input("Enter an English word: ")

5 0

2 years ago

Create pseudocode that could be used as a blueprint for a program that would do the following: An employer wants you to create a

mestny [16]

Answer:

START LOOP FOR EACH EMPLOYEE:

INPUT employee’s name, hourly rate of pay, number of hours worked, overtime pay rate, payroll deductions, tax rate

SET gross pay = (hourly rate of pay x *weekly hours) + (overtime pay rate x (number of hours worked - *weekly hours))

PRINT gross pay

SET net pay = gross pay - (payroll deductions + (gross pay * tax rate/100 ))

PRINT net pay

END LOOP

* weekly hours (how many hours an employee needs to work to earn overtime pay rate) is not given in the question

Explanation:

Create a loop that iterates for each employee

Inside the loop, ask for name, hourly rate, number of hours worked, overtime pay rate, payroll deductions, tax rate. Calculate the gross pay and print it. Calculate the net pay and print it

8 0

3 years ago

The _________ contains frequently used formatting commands that are displayed when selecting text or objects with the mouse.

kolbaska11 [484]

The Answer is toolbar.
The mini or small toolbar contains frequently used formatting commands that are displayed when selecting text or objects with the mouse.
Toolbar is also known as Ribbon. It is present in computer interface design. We can see toolbar in many softwares like Microsoft office suite, web explorer, designing softwares etc. it is mostly present under the menu bar and it has many options.

3 0

3 years ago