Insert record of 5 salary levels in the salary table
[ad_1]
Task 1: Create three tables with relevant keys as suggested in the above diagram
Task 2: Insert record of 10 employees in the employee table
Task 3: Insert record of 5 departments in the department table
Task 4: Insert record of 5 salary levels in the salary table
Task 5: Write a query to display the information about the employees in the employee
table
Task 6: Write a query to display the name of all the employees
Task 7: Write a query to display the name of all the employees and their jobname.
Task 8: Write a query in SQL to display the unique jobname for all the employees
Task 9: Write a query to increase the salary for all the employees by 12%. Display the
empname, jobname and salary after the increment
Task 10: Write a query to display the employee names with minimum and maximum
salary.
Task 11: Write a query to display the employee id, employee name, jobname of all the
employees whose salary is greater than 90,000 P.A.
[Button id=”1″]
[ad_2]
Source link
"96% of our customers have reported a 90% and above score. You might want to place an order with us."
