Learning, Free job alert & More
This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Display the cumulative percentage of total sales for each product. sale_id product_id sales 1 101 500.00 2 102 300.00 3 103 200.00 4 101 400.00 5 102 600.00 6 103 800.00 7 104 1000.00 … Read more
This question was asked in Interview at black rock. read more Company: BlackRock CTC: 26LPA SQL Interview Question Question Q. Write a query to group employees by age ranges (e.g., 20–30, 31–40) and count the number of employees in each group. Solution age-range num_employee 21-30 7 31-40 6 41-50 5 51-60 2 View on DB … Read more
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 influenced by Vilfredo Pareto, an Italian economist who discovered that 20% of the people controlled 80% of the land in Italy. Over time, this approach … Read more
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 SQL query to find the total score for each gender at each day. Order the result table by gender and day. Solution Explanation The solution … Read more
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 an SQL query to recommend pages to the user with user_id = 1 using the pages that your friends liked. It should not recommend pages you already liked. … Read more