1164 Product Price at a Given Date

1164 Product Price at a Given Date

1164. Product Price at a Given Date: Learn how to track and select price from continuously changing series. Read more Company: MAANG Difficulty: Medium Source: LeetCode SQL Interview Question: 1164. Product Price at a Given Date Question. Write a solution to find the prices of all products on 2019-08-16. Assume the price of all products before any change … Read more

Page Recommendations: Write an SQL query to recommend pages to the user

Page Recommendations

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

Retrieve the name of the manager who supervises the most employees

SQL Interview question Black Rock Data Analyst

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 the most employees. To achieve this, the query works in the following steps: Key Logic: Summary: The query counts how many employees each manager supervises, … Read more

Write a query to calculate the median salary of employees in a table.

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 median salary from the employees table. To calculate the median salary, we need some essential information, like the total number of employees in the table. … Read more