This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question…
This question was asked in Interview at black rock. read more Company: BlackRock CTC: 26LPA SQL Interview Question Question Q.…
The Pareto Principle, commonly known as the 80/20 rule, argues that 80% of the results are achieved with 20% of…
This question was asked in Facebook interview, Ask is to provide Running Total for Different Genders. Source: LeetCode Difficulty: Medium…
Understanding the SQL LAG Function (With Examples) SQL LAG function is a powerful tool that enables you to access data…
This question was asked in Facebook interview, Ask is to give page recommendation for user1 based on Friendship and Likes.…
Company: BlackRock CTC: 26LPA Source: Linked Post Q. Retrieve the name of the manager who supervises the most employees. Solution: SELECT…
Company: BlackRock CTC: 26LPA Source: Linked Post Q: Write a query to calculate the median salary of employees in a…
Query: SELECT product_id FROM sales GROUP BY product_id HAVING COUNT(DISTINCT region_id) = (SELECT COUNT(*) FROM regions); Explanation: We need to…