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:
program :
def separate_int_and_str(list_1):# function to seprate the list.
str_list=[] #list to hold the
int_list=[]#list which holds the integer value.
for x in list_1: #for loop to extract the list.
if(type(x)==str): #if condition to check the type of the element.
str_list.append(x)#create a list for the string value.
elif(type(x)==int): #check condition for th einteger value.
int_list.append(x)#create a list for the integer value.
Explanation:
- The above-defined function is written in the python language, which used the code to separate the list for integer and the string value.
- There are two lists define in the function which holds the integer and the string value separately.
- There is a 'for' loop which scans the element of the list and checks the list by the help of type function which tells the class of the element.
- Then if the type function states that the element is from the strong class, it will assign the element on the string list otherwise it assigns the element in the integer list.
The answer most likely B NOT SURE )
Answer:
Incremental technique is the way in which software is built and delivered in pieces. The concept is to keep the client and developer on same page and the client is known as a non tech person, so he should be given software in piece by piece to avoid any confusion and sudden change.
Agile method is the best example of this technique in which steps are defined on contract basis and the software is delivered and build by pieces to keep client and developer on same page.
