Answer:
Begin the statement with the proper keyword to start the loop
Explanation:
Given
The code segment
Required
Fix the code
The first line of the code segment is meant to be a for loop, but it does follow the right syntax.
This is so because the for keyword is missing.
The first line should be corrected and replaced with:
for count in range(80):
Hence, option (b) is correct
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.
Answer:
The python function is as follows:
def fact(N):
factorial = 1
for i in range(1,N+1):
factorial = factorial * i
return(factorial)
Explanation:
This line defines the function
def fact(N):
This line initializes the product of 1 to N to 1
factorial = 1
This line iterates through 1 to N
for i in range(1,N+1):
This line calculates the product of 1 to N i.e. factorial
factorial = factorial * i
This line returns the factorial
return(factorial)
A web designers favorite snack is cookies.
