SQL LAG function explained!!
Understanding the SQL LAG Function (With Examples) SQL LAG function is a powerful tool that enables you to access data from the previous row, which is related to the current …
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 …
Identify products that were sold in all regions.
Query: SELECT product_id FROM sales GROUP BY product_id HAVING COUNT(DISTINCT region_id) = (SELECT COUNT(*) FROM regions); Explanation: We need to find products that have been sold in all regions. This …