"Clarifying question:
Am I the first one to notice the fire, or there are people already on it?
Extent and source of fire - I am assuming it's localized and I am inside the data center, safe so far.
Response:
It is an emergency. I will do and coordinate the people to do the following in parallel, if I am the first one to know.
Get immediate attention of folks in the data center. Get someone and many people to call 911 and security. Coordinate to have people in need evacuated.
Turn off th"
Bg - "Clarifying question:
Am I the first one to notice the fire, or there are people already on it?
Extent and source of fire - I am assuming it's localized and I am inside the data center, safe so far.
Response:
It is an emergency. I will do and coordinate the people to do the following in parallel, if I am the first one to know.
Get immediate attention of folks in the data center. Get someone and many people to call 911 and security. Coordinate to have people in need evacuated.
Turn off th"See full answer
"Clarifying questions and Assumptions
ChatGPT search means the search function inside the chat app? OR ChatGPT search Chrome extension? Assumption: Search inside the chat app.
Is there any location restriction in this analysis? Assumption: USA only.
Is there any user segment restriction in this analysis? Assumption: All user segments.
Are we assuming the ChatGPT search already exists or going back in time before the ChatGPT search existed? Assumption: Go back in time"
Darpan D. - "Clarifying questions and Assumptions
ChatGPT search means the search function inside the chat app? OR ChatGPT search Chrome extension? Assumption: Search inside the chat app.
Is there any location restriction in this analysis? Assumption: USA only.
Is there any user segment restriction in this analysis? Assumption: All user segments.
Are we assuming the ChatGPT search already exists or going back in time before the ChatGPT search existed? Assumption: Go back in time"See full answer
"By increasing the number of paid users, I assume we mean that we want to increase the % of DAUs who pay for YT Music.
First, we need to understand the Youtube Music play here.
Youtube Music was carved out of Youtube because Spotify and Apple Music were getting popular. Users were listening to music on Spotify instead of on Youtube, threatening ad revenue for Youtube. Therefore, Youtube Music was born as a standalone app, where users could listen to the music ad free from anywhere anytime.
In"
Priyansh J. - "By increasing the number of paid users, I assume we mean that we want to increase the % of DAUs who pay for YT Music.
First, we need to understand the Youtube Music play here.
Youtube Music was carved out of Youtube because Spotify and Apple Music were getting popular. Users were listening to music on Spotify instead of on Youtube, threatening ad revenue for Youtube. Therefore, Youtube Music was born as a standalone app, where users could listen to the music ad free from anywhere anytime.
In"See full answer
"Required output in the solution not the one requested from the question. only customerid, firstname, last_name and years were required. Please this needs to be very clear.
Otherwise my answer is
with totalorderyear as (
SELECT
o.customer_id,
c.first_name,
c.last_name,
EXTRACT(YEAR FROM o.orderdate) AS orderyear,
COUNT(o.orderid) AS totalorders
FROM orders o
LEFT JOIN customers c
ON c.customerid = o.customerid
GROUP BY o.customerid, c.firstname, c.last"
Gloriose H. - "Required output in the solution not the one requested from the question. only customerid, firstname, last_name and years were required. Please this needs to be very clear.
Otherwise my answer is
with totalorderyear as (
SELECT
o.customer_id,
c.first_name,
c.last_name,
EXTRACT(YEAR FROM o.orderdate) AS orderyear,
COUNT(o.orderid) AS totalorders
FROM orders o
LEFT JOIN customers c
ON c.customerid = o.customerid
GROUP BY o.customerid, c.firstname, c.last"See full answer
Coding
SQL
🧠Want an expert answer to a question? Saving questions lets us know what content to make next.
"Understand the business problem: Identify the business problem that the AI data product is intended to solve.
Identify the target audience: Understand who will be using the data and what problem they will be solving for using the data. This will inform the features and functionality that should be included in the product.
Gather and preprocess the data: Collect and preprocess the data that is relevant to the problem that it is being solved for. This will inform the AI algorithm"
M D. - "Understand the business problem: Identify the business problem that the AI data product is intended to solve.
Identify the target audience: Understand who will be using the data and what problem they will be solving for using the data. This will inform the features and functionality that should be included in the product.
Gather and preprocess the data: Collect and preprocess the data that is relevant to the problem that it is being solved for. This will inform the AI algorithm"See full answer
"In my previous role as a Team Leader at XYZ Corporation, our department was facing high turnover rates, and the skill levels within the team were not meeting the company's evolving demands. We were in the midst of a major project that required a skilled and cohesive team to deliver on tight deadlines.
My primary responsibility was to enhance team development and retention. Specifically, I needed to reduce turnover by 20% within six months and improve team competency to handle new project requir"
Alexander R. - "In my previous role as a Team Leader at XYZ Corporation, our department was facing high turnover rates, and the skill levels within the team were not meeting the company's evolving demands. We were in the midst of a major project that required a skilled and cohesive team to deliver on tight deadlines.
My primary responsibility was to enhance team development and retention. Specifically, I needed to reduce turnover by 20% within six months and improve team competency to handle new project requir"See full answer
"Background Context
I'm a PM at a venture-backed SaaS in the legal tech space. We provide end-to-end contract management experience for our customers with the following features:
Upload - Contracts signed in DocuSign, etc. automatically uploaded to our system through API integrations.
Data Extraction - Contract terms such as payment terms and key dates are automatically OCRed and extracted using ML.
Analytics - Contract terms are searchable, filter, and customize for reporting.
Work"
Christopher K. - "Background Context
I'm a PM at a venture-backed SaaS in the legal tech space. We provide end-to-end contract management experience for our customers with the following features:
Upload - Contracts signed in DocuSign, etc. automatically uploaded to our system through API integrations.
Data Extraction - Contract terms such as payment terms and key dates are automatically OCRed and extracted using ML.
Analytics - Contract terms are searchable, filter, and customize for reporting.
Work"See full answer
"#inplace reversal without inbuilt functions
def reverseString(s):
chars = list(s)
l, r = 0, len(s)-1
while l < r:
chars[l],chars[r] = chars[r],chars[l]
l += 1
r -= 1
reversed = "".join(chars)
return reversed
"
Anonymous Possum - "#inplace reversal without inbuilt functions
def reverseString(s):
chars = list(s)
l, r = 0, len(s)-1
while l < r:
chars[l],chars[r] = chars[r],chars[l]
l += 1
r -= 1
reversed = "".join(chars)
return reversed
"See full answer
"You're the PM for all of Instagram Stories. What is your North Star metric?
Meta's Mission: Give people the power to build community and bring the world
closer together.
IG's Mission: To capture and share the world's moments
User Types
Marketplace / 2-sided ecosystem
Creators and the Consumers
Metric Categories
Adoption
Engagement
Retention
[not pictured]: create a table with 2 columns: Creators and Consumers and 3 rows: Adoption, Engagement, Retention.
Talked through and priori"
Daniel L. - "You're the PM for all of Instagram Stories. What is your North Star metric?
Meta's Mission: Give people the power to build community and bring the world
closer together.
IG's Mission: To capture and share the world's moments
User Types
Marketplace / 2-sided ecosystem
Creators and the Consumers
Metric Categories
Adoption
Engagement
Retention
[not pictured]: create a table with 2 columns: Creators and Consumers and 3 rows: Adoption, Engagement, Retention.
Talked through and priori"See full answer
"Clarify the question. Any specific system?
Will study the related systems in the environment.
Will define the goal, attributes of the system, stakeholders expectations, problems this system is going to address in case these things don't exist already.
With the above two steps, I Will come up with a draft of the System KPI.
Will run it with leadership, stakeholders and will incorporate feedback.
In parallel, will come up with quantification on these performance factors.
Fina"
Anonymous Krill - "Clarify the question. Any specific system?
Will study the related systems in the environment.
Will define the goal, attributes of the system, stakeholders expectations, problems this system is going to address in case these things don't exist already.
With the above two steps, I Will come up with a draft of the System KPI.
Will run it with leadership, stakeholders and will incorporate feedback.
In parallel, will come up with quantification on these performance factors.
Fina"See full answer
"That is a great product opportunity. I see the vision to drive engagement by building a reward based experience to encourage kids to login to the app and track their books and trigger a visual pleasing experience when the child completes a book. The more complex the book, the bigger the reward."
Christina Z. - "That is a great product opportunity. I see the vision to drive engagement by building a reward based experience to encourage kids to login to the app and track their books and trigger a visual pleasing experience when the child completes a book. The more complex the book, the bigger the reward."See full answer
"This interviewee had a decent framework but the specifics weren't impressive. I wouldn't post this as an example and would appreciate if you could replace this video."
Anonymous Deer - "This interviewee had a decent framework but the specifics weren't impressive. I wouldn't post this as an example and would appreciate if you could replace this video."See full answer
"I've recently worked closely with a product that had both the best and worst performing teams.
The situation is that one team is struggling to deliver within a reasonable timeframe, a few stronger members of the team are carrying the weaker. Work is taking a long time. They aren't listening to each other. They aren't helping each other to get work over the line. They are getting stuck down rabbit holes. They aren't continually improving their processes. They are getting frustrated and at risk o"
James W. - "I've recently worked closely with a product that had both the best and worst performing teams.
The situation is that one team is struggling to deliver within a reasonable timeframe, a few stronger members of the team are carrying the weaker. Work is taking a long time. They aren't listening to each other. They aren't helping each other to get work over the line. They are getting stuck down rabbit holes. They aren't continually improving their processes. They are getting frustrated and at risk o"See full answer