Given an array of integers named ages, which of the following will query this array to get all values less than 20 and store the result in teens? Question 8 options: a) int teens = from item in ages where item < 20 select item; b) var teens = from ages where item < 20 select item; c) var teens = from item in ages where item < 20 select item; d) var ages = from item in teens where item < 20 select item;

Student Number, Grade 101029383,90 192736611,10 109800384,0 292833315,80 Complete the function below. If a line is long, you may write it in multiple lines at one blank, but please only write a single statement. def write_final_grades (assignment_grades: Dict, resubmit_grades: Dict, fname: str) -> None: """Write final marks to a final grade file named fname. assignment_grades maps student numbers to grades for the original assignment submission. resubmit_grades maps student numbers to grades for the resubmission of the same assignment. The resubmit penalty of 20% has not been applied within resubmit_grades. The higher mark, after resubmit penalties are applied, is the final mark for a student. Assume that the same student IDs are in both dictionaries. Assuming "grades.txt" is the original grade file shown (on the previous page) and "resubmit.txt" is the file above this function header:>>> original = make_dictionary ("grades.txt")>>> resubmit = make_dictionary ("resubmit.txt")>>>...

The logic will allow the user to: Load a single dimensional array of size 50 with a random number The random number will range from 1 to 1,000 (you may have duplicate values) Find the highest value and the index location that it was in Find the smallest value and the index location that it was in Display the array’s contents. Display the highest value and its index location Display the lowest value and its index location Allow the user to execute this application multiple times (some sort of loop?) You will need one for loop to load the array as well as one or two for loops to search that array. The rand also has a "nasty" tendency to create the same results repeatedly in an exe. To avoid that, we have to "shuffle the deck" every time. This ensures that all numbers are an equal probability of appearing and not the same set of values (would create a boring game). // Add this to "shuffle the deck" every time to ensure that // different values could occur else the exe produces the...

In Python, grades_dict = {'Wally': [87,96,70], 'Eva': [100,87,90], 'Sam': [94,77,90], 'Katie': [100,81,82], 'Bob': [83, 65, 85]} Ask user to enter the names of the rows, i.e., indices. You can use: len(grades) to get the number of rows of the DataFrame. In addition, using the sort_index() method, ask user whether they wish to sort by rows or by columns and whether to sort in ascending or descending order (do not use any if-else statements)

the code CREATE FUNCTION Calculate_Monthly_Payment( @mortage_amount BIGINT , @apr DECIMAL(18, 6) , @years INT)RETURNS DECIMAL(18, 6)ASBEGIN /* A = P (i + i (1+i) −1 n ) where: A = Monthly Payment Amount P = Principle (Initial) Mortgage Amount i = APR / 12 = Monthly Interest Rate n = years * 12 = Total Number of Payments */ -- Calculate monthly interest rate DECLARE @i DECIMAL(18, 6) SET @i = @apr / 12 DECLARE @n INTEGER SET @n = @years * 12 RETURN (@mortage_amount *@i * POWER(1+@i,@n)) / (POWER(1+@i, @n) - 1) END isn't working it shows that ERROR: syntax error at or near "@" LINE 3: @mortage_amount BIGINT ^ SQL state: 42601 Character: 48

Question four

The subscript identifies the of a particular element in the array. O range value O location name

There are 2 arrays, the first contains item numbers in inventory and the second parallel array contains the price of the items. The user will enter the item number they want to purchase, the program checks to see if it is a valid entry. If it is valid, it will tell the user the price of the item. If it is an invalid item, a message will display telling the user they entered an invalid item. Type up the code below, execute the program a few times.

Task 2 Use function to calculate Computer Skills. Both skills Yes: show "Sufficient", only one skill: show "Good", no skill: show "Poor" Computer Skills Student ID 521370 811298 780223 528112 427747 207676 158877 154194 480967 962948 701444 803700 268544 975048 204401 846716 127466 621984 285594 826758 972888 739477 857713 339297 249521 868320 872950 198271 702356 726662 365857 136850 492928 850557 987114 776815 666031 904552 161237 268716 Software Skill Yes Yes Yes No Yes Yes No Yes No No Yes No No Yes Yes No No No Yes Yes Yes Yes Yes Yes Yes Yes No Yes No Yes No Yes No Yes No Yes No Yes Yes Yes Hardware Skill No Yes Yes No Yes Yes No No Yes No Yes No No No No Yes No No No No Yes Yes Yes Yes No No Yes No Yes No Yes Yes | No Yes Yes Yes No Yes Yes Yes