SQL

State one situation where the set-based solution is advantageous over the cursor-based solution.

For what purpose we are using view? How is it created to get the job done?

Give some problems or scenarios where map-reduce concept works well and where it doesn’t work.

Write a SQL query to find the 10th highest employee salary from an Employee Table. Explain your answer. (Note: You may assume that there are at least 15 records in the Employee Table)

Write a function that takes in a list of dictionaries with a key and list of integers and returns a dictionary with the standard deviation of each list. Note that this should be done without using the numpy built in functions.

You notice a system uses a lot of triggers to enforce foreign key constraints, and the triggers are error-prone and difficult to debug. What changes can you recommend to reduce the use of triggers?

You have data of people who have applied for a lottery ticket. The data consists of their ticket number. You have to choose winners by selecting the people present in rows divided by 3 or 7, but not both. Write a ...

Temperatures of a particular area were recorded in a table. Write a SQL query to find the date along with the IDs whose temperature is lower from the next day. ID Date Temperature (c) 1001 2020-03-11 17 1002 2020-03-12 20 1003 2020-03-13 31 1004 2020-03-14 23

Take reference from the previous question, Query I In the same Table 3, find the employee with highest salary and arrange them in the alphabetical order of their last name.

You have got some data in the Table 1 and Table 2 Table 1 Id Last_Name First_Name Title E0011 Verma Nikita Technician E0012 Jordan Chris HR E0013 Samson Nil Assistant E0014 Smith Joe In charge   Table 2 Id Salary E0013 80,000 E0012 65,000 E0011 70,000 E0014 75,000   Write a SQL query to create a Table 3 that contains the following columns- Id, First_Name, Last_Name, Salary (Hint- The columns should be in the prescribed order)