See the below tables and solve the given queries.

Table: Employee

 

 

Table: Incentives

 

 

Questions

1. Select employee details from employee table if data exists in incentive table.
2. Get Employee ID's of those employees who didn't receive incentives.
3. Select 20 % of salary from John, 10% of Salary for Roy and for other 15 % of salary from employee table.
4. Select Banking as 'Bank Dept', Insurance as 'Insurance Dept' and Services as 'Services Dept' from employee table.
5. Select max incentive with respect to employee from employee and incentives table using sub query.
6. Select 2nd Highest salary from employee table using sub query.
7. Show different dept as columns and number of employee in that dept as rows.
8. Show different salary as columns and number of employee with that salary as rows.

Note:

1. Upload screenshots containing query and its output in either jpg or png format.
2. Name of screenshot file name must be Question No. i.e. 1.jpg or 1.png.
3. Optional questions are not required to submit.