A. review or print them later
The similarities are: in both programs you can type letters, insert images, hyperlinks.
Answer:
Following are the code to this question:
list_val = input()#defining a integer variable for input value
test_grades = list(map(int, list_val.split()))#defining test_grades as a list
sum_extra = -999 #defining sum_extra that holds negative integer value
sum_extra = 0#defining sum_extra that holds value
for y in range(len(test_grades)):#defining a for loop to check range of list
if(test_grades[y] > 100):# defining if block that check list value is greater then 100
sum_extra = sum_extra + (test_grades[y] - 100)#use sum_extra variable to hold extra value and add this value
print('Sum extra:', sum_extra)#print value
Output:
101 83 107 90
Sum extra: 8
Explanation:
In the above code a, "list_val" variable is declared, that uses an input method to input the values and declared a "test_grades" variable that uses a list method to add all values in the list.
In the next step, the "sum_extra" variable is declared, which holds some values and defines a for loop to check the range of the "test_grades", and define a if block, that checks list value is greater than 100. If the condition is true, it will remove the extra value, and add it into the sum_extera variable and add its value, and at the last use, print variable to print its value.
Answer:
SELECT DISTINCT VendorName FROM Vendors
WHERE VendorName= ANY (SELECT VendorName FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID) ORDER BY VendorName;
Explanation:
All bold faced words are sql keywords for different purposes. The subquery return the all values which matches the join condition and main query will choose only distinct values and make them in order of VendorName.
There many other queries also return the same result as returned by given query.
