Another question

Please help me to write this code following the data table I update below 1. Determine the Appropriate Function and Write a QUERY: ─ Use the HR Database, employees table, the salary column, and bonus column. ─ In the SELECT add together salary and bonus, give it an Alias. ─ If the bonus is NULL replace the NULL with a value (select your own value). ─ Format new column with comma, dollar sign and no decimal places ─ Please the individual’s first name and last name FIRST NAME LAST NAME John Doe SALARY $20,000 BONUS $5,000 Total Salary $25,000 2. Determine the Appropriate Function and Write a QUERY: ─ Choose a table that contains a startdate and enddate column. ─ Then in a single query, check to see if there is an enddate. If there is, temporarily replace it with a date of your choosing (perhaps something related to the date something would end). If there is not, replace it with today’s date. 3.Determine the Appropriate Function and Write a QUERY: Using the f_staffs table, give each employee who does not have a current overtime rate, a new overtime rate of your choosing. Please report the lastnames and the new overtime rate using an alias and in the following format: $#.##