SQL(8)
-
SQL - Second Degree Follower
Second Degree Follower Medium In facebook, there is a follow table with two columns: followee, follower. Please write a sql query to get the amount of each follower’s follower if he/she has one. For example: Explaination: Both B and D exist in the follower list, when as a followee, B's follower is C and D, and D's follower is E. A does not exist in follower list. ANALYSIS: the question asked to ..
2020.04.07 -
SQL - Department Top Three Salaries
Department Top Three Salaries Hard SQL Schema The Employee table holds all employees. Every employee has an Id, and there is also a column for the department Id. Write a SQL query to find employees who earn the top three salaries in each of the department. For the above tables, your SQL query should return the following rows (order of rows does not matter). Explanation: In IT department, Max ear..
2020.04.07