Write an SQL for the following problem and take a screen shot of the output. (3 Marks each): Task 1: Single Row Function

1) Write an SQL statement that will display the Employee ID, Last name, First name and Job ID of all employees that belong to a department with Department ID 20 and whose Job ID has a substring rep.

2) Write an SQL statement that will display the Employee ID, Last name, First name, Job ID and salary of GrantDouglas.

3) Write an SQL statement that will display the Employee ID, Last name, First name, and Job ID of all employees that belong to a department with Department ID 20 and whose remainder of their salary from 3000 is greater than 500.

4) Write an SQL statement that will display the Employee ID, Last name, First name, and Job ID of all employees working in the company for more than 15 years.