4. Using subquery, display Email, bonus with zero decimal places and name the column as "mybonus from employees table, whose managerlid is same as the employee_id of the employees, whose job id belongs to "ADV. PRES?land email begins with "SKIN. Arrange the output on email from a to z [6 Marks] 5. Using subquery, display birthdate, number of staffs in each birthdate from F_STAFFS table, whose birthdate falls either 19-Mar-1979' or 30-Mar-1969and number of staffs in which birthdate is below to all the staffs, thos staff's salary is less than 70. Arrange the output on birthdate from highest to lowest. [5 Marks] 6. Design and execute a SQL query that correctly uses the CASE function and Employees table to display FIRST NAME, the hire date is going to have four months added to it which the first Monday following the day and name the column as Next Evaluation day. A new column named as "Salary Updates using a column job id, with the case, expression as follows; If the job_id is 'AD VP', display 17000 If the job_id is AD ASST display 4400 If the job_id is 'AC MGR', display 12000 Otherwise, display 20000 Restrict the output for all employees, whose HIRE DATE before '11-May-1996'. Arrange the output by First Name from A to Z. [6 Marks)