Vishal

Hi, I am Vishal Jaiswal, I have about a decade of experience of working in MNCs like Genpact, Savista, Ingenious. Currently i am working in EXL as a senior quality analyst. Using my writing skills i want to share the experience i have gained and help as many as i can.

Running Total for Different Genders: Write an SQL query to find the total score for each gender at each day

by
Running Total for Different Genders

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

SQL LAG function explained!!

by
SQL LAG function

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 row as well. It’s incredibly useful for trend analysis. For example, if you are tracking how much a stock price has changed from the previous … Read more

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

by
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

by
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.

by
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