Insert record of 5 salary levels in the salary table

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."

Essay Writing Service
Affordable prices

You might be focused on looking for a cheap essay writing service instead of searching for the perfect combination of quality and affordable rates. You need to be aware that a cheap essay does not mean a good essay, as qualified authors estimate their knowledge realistically. At the same time, it is all about balance. We are proud to offer rates among the best on the market and believe every student must have access to effective writing assistance for a cost that he or she finds affordable.

Caring support 24/7

If you need a cheap paper writing service, note that we combine affordable rates with excellent customer support. Our experienced support managers professionally resolve issues that might appear during your collaboration with our service. Apply to them with questions about orders, rates, payments, and more. Contact our managers via our website or email.

Non-plagiarized papers

“Please, write my paper, making it 100% unique.” We understand how vital it is for students to be sure their paper is original and written from scratch. To us, the reputation of a reliable service that offers non-plagiarized texts is vital. We stop collaborating with authors who get caught in plagiarism to avoid confusion. Besides, our customers’ satisfaction rate says it all.

© 2022 Homeworkcrew.com provides writing and research services for limited use only. All the materials from our website should be used with proper references and in accordance with Terms & Conditions.

Scroll to Top