This is a simple test or assignment to see how comfortable someone is using SQL at the beginner to advanced level. Exercises of this nature will undoubtedly aid in skill improvement. The simplest method of learning is through practice and exercise problems.
This is unrelated to Microsoft examinations or their format. Simply put, I’m testing your SQL knowledge.
Requirement:
During yearly reviews, you are required to revise the salaries of the staff members in each department. You are required to alter the compensation in accordance with the percentages listed below, one for each department.
a) If “SALES” is the department, the compensation must increase by 10%.
b) If “RESEARCH” is the department, the compensation should be raised by 8%.
c) For “ACCOUNTING” the salary should be increased by 5%
d) For the remaining departments the salary should be increased by 2%
Dataset:
Consider “Emp and Dept” datasets. Download the sample dataset from here.
For answer, click here.
Big Data and SQL 
One comment