$1.[5$ Marks$]$ Write a PL$/$SQL script to find out how many cars has a salesman sold. You

have to prompt the user for the salesman$$s name. Use SI database.

$2.[5$ Marks$]$ Create a PL$/$SQL script to print the average sale price of the cars sold for each

make and model, having the average sale price greater than $40500.$ Use SI database.

$3.[5$ Marks$]$ Create a PL$/$SQL script that retrieves and displays information for all

employees in the Employees table. For each employee, if the commission is null, print

only the salary amount. Otherwise, print the total amount, which is the sum of the salary

and the salary multiplied by the commission percentage. Us HR database.

$4.[5$ Marks$]$ Write a SQL query to display the department ID$,$ department name, job ID$,$ the

average salary for that job within the department, and the number of employees with that

job in each department. Use HR database.