What is Pareto Principle
The Pareto Principle, commonly known as the 80/20 rule, argues that 80% of the results are achieved with 20% of the effort. Joseph M. Juran introduced this idea, which was …
sql interview questions
Running Total for Different Genders: Write an SQL query to find the total score for each gender at each day
This question was asked in Facebook interview, Ask is to provide Running Total for Different Genders. Source: LeetCode Difficulty: Medium Company: Facebook Running Total for Different Genders Q. Write an …
Page Recommendations: Write an SQL query to recommend pages to the user
This question was asked in Facebook interview, Ask is to give page recommendation for user1 based on Friendship and Likes. Source: LeetCode Difficulty: Medium Company: Facebook Page Recommendations Q. Write …
Retrieve the name of the manager who supervises the most employees
Company: BlackRock CTC: 26LPA Source: Linked Post Q. Retrieve the name of the manager who supervises the most employees. Solution: Explanation: Here, we want to find out the manager who supervises …
Write a query to calculate the median salary of employees in a table.
Company: BlackRock CTC: 26LPA Source: Linked Post Q: Write a query to calculate the median salary of employees in a table. Solution: Explanation: Here we need to find out the …