See the below tables and solve the given queries.

Table: Employee

 

 

Table: Incentives

 

 

Questions

1. Select department, total salary with respect to a department from employee table where total salary greater than 800000 order by Total_Salary descending.
2. Select employee details from employee table if data exists in incentive table.
3. Get Employee ID's of those employees who didn't receive incentives without using sub query.
4. Select 20 % of salary from John, 10% of Salary for Roy and for other 15 % of salary from employee table.
5. Select first_name, incentive amount from employee and incentives table for those employees who have incentives.
6. Select first_name, incentive amount from employee and incentives table for those employees who have incentives and incentive amount greater than 3000.
7. Select first_name, incentive amount from employee and incentives table for all employees who didn't get incentives.
8. Select first_name, incentive amount from employee and incentives table for all employees who got incentives using left join.

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.