sql queries 5

Pronursingexperts.com empowers students by providing them with the tools they need to succeed. By alleviating the burden of homework assignments, students can focus on gaining a deeper understanding of their coursework, engaging in extracurricular activities, and developing essential life skills. Academic success is not solely about grades; it’s also about building confidence. When students receive well-researched and impeccably written assignments from Pronursingexperts.com, they gain confidence in their abilities. This newfound confidence often translates into improved performance in their classes. In the ever-evolving landscape of education, Pronursingexperts.com stands as a beacon of support, guiding students towards academic excellence. With its unwavering commitment to quality, individual attention, and timely delivery, Pronursingexperts.com has rightfully earned its reputation as the best academic writing company. By assisting students in their academic endeavors, this platform is not just completing homework; it’s building the foundation for a brighter, more successful future for students around the world.

Question 1

Create a table with the below scenario:

Company A wants to maintain the list of employees. Here are the details Company A wants to track:

  • First Name
  • Last Name
  • A Unique Id to each employee.
  • Gender.
  • Data of birth,
  • Age
  • Joined date
  • Phone number
  • email
  • Whether employee is currently with organization or left the organization
  • Job roles( Assume that roles of organization are 100,101,102,103 and default is 101)

Above example should include all the constraints such as Default, NotNull, and Unique.

All working class age should be between 20-60.

Question 2

  • Now Company A wants to track aadhar no as well in addition to the existing details .
  • Company A can search people using Aadhar number as well.

Question 3

  • Add 10 records to the Table.
  • Do the Delete and Truncate. Write down the difference

Question 4

  • Write a Query to list the people whose name starts with Chand ends with ed.
  • Write a query to display only 3 rows without writing any condition.
  • Write a Query to display First Name column name as fnand Last Column name as ln.
  • Write a Query to find the second highest age of the employee
  • Write a query to find the third largest age of the employee
  • Write a query to find the people with maximum service with the organization.

Question 5

  • Create a table to track the leave details. Here are the details Company A wants to track: Employee Id
  • Leave type (Only Sick leave and Earned leaves are applicable)
  • Start Date
  • End Date
  • Insert sample Data here .At least 20 records

Question 6

  • Write a Query display the employee details who has not taken single leave in last one year Write a Query to display the employee details who has taken maximum leaves
  • Write a query to display the employee details who has taken maximum leaves in the last one month.
  • Write a query display the employee name and leaves taken in the current financial year.

Question 7

  • Create a table to maintain the leaves as per the job levels
  • Assume that here are the leaves as per job level:

Job level

Sick Level

Earned Leave

100

8

12

101

9

14

102

10

15

103

12

20

Question 8

  • Write the query to print employees who have taken more leaves than eligible leaves
  • Write a query to display employee name, eligible leaves and taken leaves and percent of leaves utilized.
  • Write a query to display the employee count job level wise.

Question 9

Create a table to track payroll information.

Here are the details Company A wants to track:

  • Basic
  • Allowances

Enter the sample data.

Question 10

  • Write down the Query to find the employee whose salary is highest and lowest job level wise.

Question 11

  • Create a table to track the Project allocations.
  • Here are the details of Project allocations:
  • Project name
  • Manager details
  • Employee details
  • Project budget
  • Project duration in months Enter sample data.

Question 12

  • Write the query to find the employees who are not allocated to single project.
  • Write the query to find the employees who are working as managers
  • Write the query to find the projects with high budget.
  • Write the query to find the project on which maximum employees are allocated.

Refer to the attached word document

Pronursingexperts.com recognizes that students often encounter challenging assignments that may be beyond their current skill level or require more time than they can spare due to their busy schedules. The platform steps in to provide valuable academic support by offering assistance with a wide range of assignments. Whether it’s a complex research paper, a challenging math problem set, or a literary analysis, Pronursingexperts.com ensures that students receive the guidance they need to excel. Every student is unique, and so are their academic needs. Pronursingexperts.com recognizes this and offers customized solutions. Students can communicate directly with their assigned writers, providing specific instructions and guidelines. This personal touch ensures that each assignment reflects the student’s individual style and preferences. Meeting deadlines is a critical aspect of academic success. Pronursingexperts.com understands this and prioritizes punctuality. The platform is known for its ability to deliver assignments promptly, even when facing tight schedules. This reliability allows students to submit their work on time, relieving them of the stress associated with late submissions.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

/by