"SELECT
e1.empid AS manageremployee_id,
e1.empname AS managername,
COUNT(e2.empid) AS numberofdirectreports
FROM employees AS e1
INNER JOIN employees AS e2
ON e2.managerid = e1.empid
GROUP BY e1.emp_id
HAVING COUNT(e2.emp_id) >= 2
ORDER BY numberofdirectreports DESC, managername ASC
`"
Alvin P. - "SELECT
e1.empid AS manageremployee_id,
e1.empname AS managername,
COUNT(e2.empid) AS numberofdirectreports
FROM employees AS e1
INNER JOIN employees AS e2
ON e2.managerid = e1.empid
GROUP BY e1.emp_id
HAVING COUNT(e2.emp_id) >= 2
ORDER BY numberofdirectreports DESC, managername ASC
`"See full answer
"virtual function is a member function declared with virtual keyword in a base class. It enables derived classes to redefine this function with their own specific implementations."
Sonia M. - "virtual function is a member function declared with virtual keyword in a base class. It enables derived classes to redefine this function with their own specific implementations."See full answer
"Manage Programs that are in flight
Track the progress vs Plan and see if things are on track, falling behind
Monitor Risks and update current and any new risks identified and mitigation approach
Communicate updates to stakeholders (weekly/biweekly as agreed)
Communicate status to peer TPM and partnering teams
Daily sync with Engg (like a timeboxed daily Standup to understand Daily Plan and any impediments raised that need resolving)
Facilitate Reviews with Product Manager as features"
Adib M. - "Manage Programs that are in flight
Track the progress vs Plan and see if things are on track, falling behind
Monitor Risks and update current and any new risks identified and mitigation approach
Communicate updates to stakeholders (weekly/biweekly as agreed)
Communicate status to peer TPM and partnering teams
Daily sync with Engg (like a timeboxed daily Standup to understand Daily Plan and any impediments raised that need resolving)
Facilitate Reviews with Product Manager as features"See full answer
"Whenever you look at the launching a new product you might want to follow the following framework:
Describe the product
for e.g. you are considering launching amazon go. What does Amazon go does. And what is the problem its solving. For e.g Amazon go is a new age grocery store that lets you buy product without the hassle of waiting in long queues for checkout.
Always ask clarifying questions to understand the scope.
For e.g. what will Amazon go be used for. Are we aiming it for basic grocerie"
Rani D. - "Whenever you look at the launching a new product you might want to follow the following framework:
Describe the product
for e.g. you are considering launching amazon go. What does Amazon go does. And what is the problem its solving. For e.g Amazon go is a new age grocery store that lets you buy product without the hassle of waiting in long queues for checkout.
Always ask clarifying questions to understand the scope.
For e.g. what will Amazon go be used for. Are we aiming it for basic grocerie"See full answer
Product Manager
Behavioral
+1 more
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"This is a classic Favorite Product question with a constrained product type. For this, we want to make sure it's a SaaS product. Let's go over the Favorite Product formula before diving in:
Choose a product and briefly explain what it is
Who are the users?
What are their pain points?
How did competitors solve it in the past?
How does this product address these pain points differently and better?
How would you improve it/make it better?
**Summarize"
Exponent - "This is a classic Favorite Product question with a constrained product type. For this, we want to make sure it's a SaaS product. Let's go over the Favorite Product formula before diving in:
Choose a product and briefly explain what it is
Who are the users?
What are their pain points?
How did competitors solve it in the past?
How does this product address these pain points differently and better?
How would you improve it/make it better?
**Summarize"See full answer
"Understand the rationale around why another PM has an opposing opinion. At the end of the day it cannot be your word against mine and the opinion has to be data-based.
Taking time to listen and asking clarification questions will promote a healthy partnership
Once we get the perspective, Look for data points that can support my POV over the other PMs POV
Lastly evaluate if we can land on a 51-49% approach where we find a middle ground to accommodate another pm's opinion/solution as"
Anonymous - "Understand the rationale around why another PM has an opposing opinion. At the end of the day it cannot be your word against mine and the opinion has to be data-based.
Taking time to listen and asking clarification questions will promote a healthy partnership
Once we get the perspective, Look for data points that can support my POV over the other PMs POV
Lastly evaluate if we can land on a 51-49% approach where we find a middle ground to accommodate another pm's opinion/solution as"See full answer
"You should be able to identify this as a Strategy Question, which asks you to justify high-level business decisions and strategy. Be concise and to the point.
> The underlying theme I can see in these services is that they all encourage people to start online businesses. This helps Stripe since their main product is the ability to handle online transactions. Stripe takes a percentage fee from each transaction, so it's in their best interest to encourage the growth of internet-enabled busines"
Exponent - "You should be able to identify this as a Strategy Question, which asks you to justify high-level business decisions and strategy. Be concise and to the point.
> The underlying theme I can see in these services is that they all encourage people to start online businesses. This helps Stripe since their main product is the ability to handle online transactions. Stripe takes a percentage fee from each transaction, so it's in their best interest to encourage the growth of internet-enabled busines"See full answer
"What kind of experiences do you recommend I put on my resume to be a compelling PMM candidate at big tech companies like FAANG?"
Mitchell K. - "What kind of experiences do you recommend I put on my resume to be a compelling PMM candidate at big tech companies like FAANG?"See full answer
"The cases where data is under heavy outlier influence. Since mean fluctuates due to the presence of an outlier, median might be a better measure"
Himani E. - "The cases where data is under heavy outlier influence. Since mean fluctuates due to the presence of an outlier, median might be a better measure"See full answer
"A peer-to-peer car rental is a 2-sided marketplace, with two types of users : 1) those who want to rent a car (demand), 2) those looking to rent out their car (supply). So, there are two main challenges for us to solve for through our MVP: 1) the classic (critical mass) marketplace problem of ensuring enough demand and supply. Either side will not find the product useful unless, there is enough of the other group of users, 2) In the case of peer-to-peer car rental, we are also trying to change u"
Preethi R. - "A peer-to-peer car rental is a 2-sided marketplace, with two types of users : 1) those who want to rent a car (demand), 2) those looking to rent out their car (supply). So, there are two main challenges for us to solve for through our MVP: 1) the classic (critical mass) marketplace problem of ensuring enough demand and supply. Either side will not find the product useful unless, there is enough of the other group of users, 2) In the case of peer-to-peer car rental, we are also trying to change u"See full answer