Chapter 3, Problem 3.10CP

Q. Write a trigger that checks the length of a contract when a new contract is inserted into longtermcontract table. If this is the first contract between the pharmacy and pharmaceutical company, the length of the contract should not be more than 12 months. If the contract is more than 12 months, the trigger should alter the end date and reduce it to 12 months after the start date. * You have to use BEFORE INSERT ON* THE INSERT STATEMENT IN THE END OF THE GIVEN CODE MUST WORK. GIVEN CODE:-- Do not change the name of the triggerdelimiter //create trigger first_contracts_length_limitation -- do not modify or delete the following lines. Do not write anything after this line.insert into longtermcontract values('parapharmaceutical', '24 South St., Fabreville, QC H7P-E2H', '2020-02-01', '2021-04-01', '***'); SCRIPT:

Given five invoices with invoice totals of 20.00, 20.00, 30.00, 50.00, and 50.00, what values will the following function return for these rows? ___________________________________________ RANK() OVER (ORDER BY invoice_total)

Correct answer will be liked, otherwise disliked

Q1: Explain the form attributes.

Write code to find the number of students who Fail/pass in CS course, if the passing mark is40. The list has 150 students.

Write an Add method that adds the contents of the decPrice variable to the lstPrices control.

What is Order By clause ?

Why is it so important to understand the function of the GROUPING SETS clause?

Please answer all the subparts completely. Thanks