"SELECT
s.Sale_Date,
SUM(si.Quantity * si.SalePrice) AS TotalRevenue
FROM Sales s
JOIN SaleItems si ON s.SaleID = si.Sale_ID
GROUP BY s.Sale_Date
ORDER BY s.Sale_Date;
"
Bala G. - "SELECT
s.Sale_Date,
SUM(si.Quantity * si.SalePrice) AS TotalRevenue
FROM Sales s
JOIN SaleItems si ON s.SaleID = si.Sale_ID
GROUP BY s.Sale_Date
ORDER BY s.Sale_Date;
"See full answer
"I most want to communicate a few principals of conflict resolution that I believe were integral in this situation, which are mutual respect, a results orientation, an unwavering focus on the user.
To that end, here’s how I’d like to structure this answer: First, I’ll tell you about the project we were working on, to provide some background for you. Second, I’ll describe the disagreement. Third, I’ll describe how we arrived at a solution, and finally, I’ll discuss how those 3 conflict resolu"
Ross B. - "I most want to communicate a few principals of conflict resolution that I believe were integral in this situation, which are mutual respect, a results orientation, an unwavering focus on the user.
To that end, here’s how I’d like to structure this answer: First, I’ll tell you about the project we were working on, to provide some background for you. Second, I’ll describe the disagreement. Third, I’ll describe how we arrived at a solution, and finally, I’ll discuss how those 3 conflict resolu"See full answer
"Clarifying Questions/Statements:
Clarify understanding of Fundraisers:
My answer: product that lets users create fundraisers for a particular cause, and invite/share it with other users to donate to that cause. Usually set for a certain target donation amount to be met, and a timeframe for which a user can donate to the cause
Are we assuming the lifecycle of the Fundraisers product today? If so, then I’d focus on engagement, since we have a meaningful amount of users on FB ap"
Arthur Y. - "Clarifying Questions/Statements:
Clarify understanding of Fundraisers:
My answer: product that lets users create fundraisers for a particular cause, and invite/share it with other users to donate to that cause. Usually set for a certain target donation amount to be met, and a timeframe for which a user can donate to the cause
Are we assuming the lifecycle of the Fundraisers product today? If so, then I’d focus on engagement, since we have a meaningful amount of users on FB ap"See full answer
"Understanding the problem:
What do we mean by email notification experience here? Is it the quantity of notifications or quality?- it's the quality of the experience i.e. how can we make the experience better & more user centric
How would you define enhance in this context?- here enhacement means improving the engagement with the emails resulting in more people viewing the photo/s on FB with email as source
Are we supposed to enhance the viewer's experience only or the creators as w"
Debajyoti B. - "Understanding the problem:
What do we mean by email notification experience here? Is it the quantity of notifications or quality?- it's the quality of the experience i.e. how can we make the experience better & more user centric
How would you define enhance in this context?- here enhacement means improving the engagement with the emails resulting in more people viewing the photo/s on FB with email as source
Are we supposed to enhance the viewer's experience only or the creators as w"See full answer
"Great question.
As a Product Manager, it is common to have to have difficult conversations with clients, stakeholders, or co-workers. This question actually reminds me of a time that I was faced with having to tell a client that the original estimate we gave them was much lower than it should have been and would, therefore, take much longer and cost a lot more as well.
In this scenario, we had to work within a client's legacy codebase and didn't realize the limitations, roadblocks, and barrie"
Kiley S. - "Great question.
As a Product Manager, it is common to have to have difficult conversations with clients, stakeholders, or co-workers. This question actually reminds me of a time that I was faced with having to tell a client that the original estimate we gave them was much lower than it should have been and would, therefore, take much longer and cost a lot more as well.
In this scenario, we had to work within a client's legacy codebase and didn't realize the limitations, roadblocks, and barrie"See full answer
Product Manager
Behavioral
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"Clarifying questions
What is Facebook Events
How does this work
Is it only desktop based or app based as well
Why Meta built it
Core idea/tenet for Facebook is to have user engagement & to build everything around it. While people continue to interact with Facebook and create content on it, to increase the duration of engagement, having capability to host virtual events ensures community participation and making Facebook go beyond status and photo updates and let people coordinate"
Mohammad M. - "Clarifying questions
What is Facebook Events
How does this work
Is it only desktop based or app based as well
Why Meta built it
Core idea/tenet for Facebook is to have user engagement & to build everything around it. While people continue to interact with Facebook and create content on it, to increase the duration of engagement, having capability to host virtual events ensures community participation and making Facebook go beyond status and photo updates and let people coordinate"See full answer
"There are two parts to this questions:
Part 1: Why did Meta create Rooms? ( limiting to video collaboration)
Answer: Potential reasons for Meta to create their own Zoom equivalent:
Provide a video collaboration platform to employees.
Due to size and global distribution of its workforce it may make economic sense to make an in-house product that is cheaper than buying an enterprise license of Zoom
Meta already has the technology and infrastructure to do videocalls and meetings because of"
Tony A. - "There are two parts to this questions:
Part 1: Why did Meta create Rooms? ( limiting to video collaboration)
Answer: Potential reasons for Meta to create their own Zoom equivalent:
Provide a video collaboration platform to employees.
Due to size and global distribution of its workforce it may make economic sense to make an in-house product that is cheaper than buying an enterprise license of Zoom
Meta already has the technology and infrastructure to do videocalls and meetings because of"See full answer
"Clarifying Questions
Is the product a digital or physical marketplace? (Digital)
Are we building an educational platform, freelance platform, or marketplace? (Freelance platform)
Are we focusing on a specific geographical location? (India)
Will the platform involve online transactions? (Yes)
User Personas
Individual Gardeners: Self-employed gardeners offering their services.
Gardening Agencies: Organizations providing gardening services.
**Educational Institutio"
Preetham m P. - "Clarifying Questions
Is the product a digital or physical marketplace? (Digital)
Are we building an educational platform, freelance platform, or marketplace? (Freelance platform)
Are we focusing on a specific geographical location? (India)
Will the platform involve online transactions? (Yes)
User Personas
Individual Gardeners: Self-employed gardeners offering their services.
Gardening Agencies: Organizations providing gardening services.
**Educational Institutio"See full answer
"Assumptions:
Geo: US
Channels: Both Mobile/Web
Includes Stocks and other kinds of tradable financial instruments
Product for end users and not for FB employees to trade stocks or financial Instruments
Separate App or integrated within the FB Blue App? Integrated within the Blue App
Constraints:None
Why might this make sense for FB?
Recently with the advent of free retail trading platforms like Robinhood stock trading has been democratized and common people, young and old, hav"
TurboPM - "Assumptions:
Geo: US
Channels: Both Mobile/Web
Includes Stocks and other kinds of tradable financial instruments
Product for end users and not for FB employees to trade stocks or financial Instruments
Separate App or integrated within the FB Blue App? Integrated within the Blue App
Constraints:None
Why might this make sense for FB?
Recently with the advent of free retail trading platforms like Robinhood stock trading has been democratized and common people, young and old, hav"See full answer
"The opening of people spending a lot time on Facebook is way too long. Almost half time of the video.
The analysis of Facebook business model should be very brief. People know Facebook business model.
Maximize the ads display while balancing the user experience is the key. She can drive to this point much faster.
Segmentation of user group feels irrelevant to the question.
I would answer the question in a different way.
Ads revenue is the single most revenue stream for Facebook. So we c"
Zhi C. - "The opening of people spending a lot time on Facebook is way too long. Almost half time of the video.
The analysis of Facebook business model should be very brief. People know Facebook business model.
Maximize the ads display while balancing the user experience is the key. She can drive to this point much faster.
Segmentation of user group feels irrelevant to the question.
I would answer the question in a different way.
Ads revenue is the single most revenue stream for Facebook. So we c"See full answer
"Netflix is a OTT platform that streams content , TV shows, movies documentaries, to the subscriber's of Netflix. Netflix has approximately 90 million subscribers in USA alone and Netflix's revenue is generated based on their subscriptions. The user buys Netflix subscription, logs in , opens profile and opens the home page of Netflix.
1. Confirmation of the Assumptions
Homepage Definition: The homepage is the screen users see after logging into their profile, showing tailored recom"
Hari priya K. - "Netflix is a OTT platform that streams content , TV shows, movies documentaries, to the subscriber's of Netflix. Netflix has approximately 90 million subscribers in USA alone and Netflix's revenue is generated based on their subscriptions. The user buys Netflix subscription, logs in , opens profile and opens the home page of Netflix.
1. Confirmation of the Assumptions
Homepage Definition: The homepage is the screen users see after logging into their profile, showing tailored recom"See full answer
"Before diving into the Solution, I would ask a few clarifying questions.
What is the scope of the fake news
What type of fake news are we focusing on - Political, Health-related, etc
Are we looking at specific examples or a general category of fake news
When you say impact, what do you mean by that? Is it time spent on posts, the nature of the engagement (e.g., likes, shares, comments), and the sentiment of the comments?
User Demographics:
what is the demographic pr"
Bhavna S. - "Before diving into the Solution, I would ask a few clarifying questions.
What is the scope of the fake news
What type of fake news are we focusing on - Political, Health-related, etc
Are we looking at specific examples or a general category of fake news
When you say impact, what do you mean by that? Is it time spent on posts, the nature of the engagement (e.g., likes, shares, comments), and the sentiment of the comments?
User Demographics:
what is the demographic pr"See full answer
"Clarifying Questions
Are we an EdTech company adding this as a new arm, or building a new product? → New product
Is the learning mode online or offline? → User can choose
Are we focusing on any specific instruments? → No, any instrument
Does our product include a marketplace for purchasing instruments? → No
Are we building a mobile app or web platform? → Both, for India location
User Personas
Music Enthusiasts – Full-time learners aim"
Preetham m P. - "Clarifying Questions
Are we an EdTech company adding this as a new arm, or building a new product? → New product
Is the learning mode online or offline? → User can choose
Are we focusing on any specific instruments? → No, any instrument
Does our product include a marketplace for purchasing instruments? → No
Are we building a mobile app or web platform? → Both, for India location
User Personas
Music Enthusiasts – Full-time learners aim"See full answer
"At a high level, the core challenge here revolves around building an effective recommendation algorithm for news.
News is an inherently diverse category, spanning various topics and catering to a wide array of user types and personas, such as adults, business professionals, general readers, or specific cohorts with unique interests. Consequently, developing a single, one-size-fits-all recommendation algorithm is not feasible.
To enhance the personalization of the news recommendation algorithm,"
Sai vuppalapati M. - "At a high level, the core challenge here revolves around building an effective recommendation algorithm for news.
News is an inherently diverse category, spanning various topics and catering to a wide array of user types and personas, such as adults, business professionals, general readers, or specific cohorts with unique interests. Consequently, developing a single, one-size-fits-all recommendation algorithm is not feasible.
To enhance the personalization of the news recommendation algorithm,"See full answer
"ATTEMPT 2:
Facebook Dating
Sign up for a dating profile if you have FB account
You see profiles of others who signed up
It’s presented in a form browse cards
Like or Not like profile
Like + Like = Match = Unlocks to exchange messages
Meetup + Date
Facebook Dating - Helping people meet to date -> potential connections or long-term partner or marriage
Users
Just to date / meet new people
Look for a meaningful relationship
Look for marriage or partners"
Anonymous Warbler - "ATTEMPT 2:
Facebook Dating
Sign up for a dating profile if you have FB account
You see profiles of others who signed up
It’s presented in a form browse cards
Like or Not like profile
Like + Like = Match = Unlocks to exchange messages
Meetup + Date
Facebook Dating - Helping people meet to date -> potential connections or long-term partner or marriage
Users
Just to date / meet new people
Look for a meaningful relationship
Look for marriage or partners"See full answer
"\# events with meaning participation (monthly). Define meaningful participation by defining thresholds for initial demand signals such as >5 RSVPs, >10 interests. Position in interview that you will work with your data science team to define this depth thresholds."
Raoul S. - "\# events with meaning participation (monthly). Define meaningful participation by defining thresholds for initial demand signals such as >5 RSVPs, >10 interests. Position in interview that you will work with your data science team to define this depth thresholds."See full answer
"Here's my structure:
Align with interviewer on understanding of the product and state key assumptions
Product rationale
What is the product (1-2 sentences)?
Why does it exist? How does it fulfill Meta's mission?
Who are the key stakeholders and users of the product?
Business goal:
Key Users and value
User type
User flow (high level)
Intersection of value
North Star Metric
Supporting metrics for different user types
Counter-metrics"
Anonymous Bird - "Here's my structure:
Align with interviewer on understanding of the product and state key assumptions
Product rationale
What is the product (1-2 sentences)?
Why does it exist? How does it fulfill Meta's mission?
Who are the key stakeholders and users of the product?
Business goal:
Key Users and value
User type
User flow (high level)
Intersection of value
North Star Metric
Supporting metrics for different user types
Counter-metrics"See full answer
"I want to work at Meta because of its reputation as a company that consistently pushes the boundaries of technology, particularly in areas like AI, machine learning, and immersive technologies such as AR and VR. I admire Meta's mission to bring people closer together and create meaningful connections, as well as its focus on long-term innovation, such as the development of the metaverse.
As an AI engineer, I'm excited about the opportunity to work on cutting-edge projects that have a global impa"
Alan T. - "I want to work at Meta because of its reputation as a company that consistently pushes the boundaries of technology, particularly in areas like AI, machine learning, and immersive technologies such as AR and VR. I admire Meta's mission to bring people closer together and create meaningful connections, as well as its focus on long-term innovation, such as the development of the metaverse.
As an AI engineer, I'm excited about the opportunity to work on cutting-edge projects that have a global impa"See full answer