Given the following table: Student ( id, first_name, last_name, address, program, phone), which of the following statements will list the number of students who are in IT program?   a. select max(*) from student where program = 'IT';   b. select sum(*) from student where program = 'IT';   c. select count(*) from student where program = 'IT';   d. select count(program) from student where program = 'IT';   One of the following is not directly supported in PL/SQL blocks   a. delete   b. alter   c. update   d. insert

Create a function that calculate the total commission

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") >>>…

You are required to write a program,to store the 10 lab scores of 10 students. Also find the sum & averageof lab scores for each student

Last Name Dev Hours Review Date Rating Salary Bonus                       Brody 6 1/5/2018 2  $ 19,840                         Alex 8 4/1/2018 5  $ 26,700                         Ashley 1 7/1/2018 4  $ 33,200                         1.  Use the logical if function to pay a bonus.  You determine the rules for the bonus.  List the rules and your steps.               For example, you may use the employee rating to align with a specific bonus percentage such as 2% for a 2 rating, 5% for a 5 rating, etc.

When is it OK to use union compatibility between two select statements that utilize the same table?

B questions 21-24, please check my work if it’s correct, thank you

Python elif if

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

1. Calculate the Overtime Pay for 5 Service men Enter the Service man Name, Enter the Type of Service, Enter Monthly Basic Salary, Enter Number of Days of Overtime. The options of Type of Service men will be "Army", “Navy" and “Airforce". If the type of Service is "Airforce'", the Overtime Rate is 30%. If the type of Service is “Army", the Overtime Rate is 28%. If the type of Service is “Navy", the Overtime Rate is 26%. Overtime pay = Daily rate * Numbers of Days Overtime * Overtime Rate. Daily rate = Monthly Basic Salary / 22. Display Service man Name / Service Type / Daily Rate / Overtime Pay for all the 5 Service men Save your shell script as servicemen.sh