SQL

Suppose there are two columns Age Name 25   Nitin 30   Amit 27   Rishab 29   Ankush Convert into Name   Nitin.  Amit. Rishab. Ankush Age.      25.       30.      27.        29

Write a SQL query to find the 7th highest employee salary from an Employee Table. If that employee is male, shift to the next employee in alphabetical order. Explain your answer.

How would you develop a model to identify plagiarism? (Hint- Relate is to a topic of your knowledge)

Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 Arrange the Emp_name in alphabetical order in the new table that only has the salary and Emp_name column in it.

Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 Employees having the same salary in the table will get a pay raise of 1000. Create a new table with the increased salary of the ...

Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 This table might have some duplicate records. Try to locate them and keep only a single copy in the table.

Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 Get the Emp_id for employees whose Dept_id is either invalid or not present in the database.

Emp_id Emp_name Manager_id Dept_id Joining_date Salary 1 Joy 0 Q 1 January, 2018 6000 2 Manu 0 5 5 July, 2019 6000 3 Ajay 1 1 13 August, 2017 2000 13 Akanksha 2 5 16 May,2020 2000 11 Surbhi 2 1 21 July, 2015 2000 9 Louise 1 - 5 September,2018 3000 8 Vishal 3 1 7 June, 2012 3500 7 Chen Lee 2 5 31 July,2018 NULL 3 Apoorva 1 1 29 February,2016 2000 Write a query to find employees who have completed more than 2 years in the company. Create a separate table containing Emp_id, salary and Joining ...

If a table contains duplicate rows, does a query result display the duplicate values by default? How can you eliminate duplicate rows from a query result?

What is the purpose of the group functions in SQL? Give some examples of group functions.