Learning, Free job alert & More
These questions were asked in a recent interview Flipkart Business Analyst, these uncovered questions are extremely important if you are applying for the same position. Flipkart Business Analyst Interview Questions SQL Questions: 1. What are window functions, and how do they differ from aggregate functions? Can you give a use case? Windows functions and aggregate … Read more
This article tackles common SQL Interview Questions asked by EY, offering detailed solutions and explanations to help aspiring data analysts prepare effectively. These SQL Interview Questions, shared by an experienced Data Analyst at EY, cover a range of SQL concepts crucial for success in the interview process. SQL Interview Questions For data analyst There are … Read more
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
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 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