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: $#.##

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.