"`select employeeid, employeename, sum(maxscore) totalscore
from (
select e.id employeeid, e.name employeename, tr.testid , max(tr.score) maxscore
from employees e
join test_results tr
on e.id = tr.employee_id
group by tr.employeeid, tr.testid
order by 1
)
group by 1,2
order by 3 desc`
`"
Abbas M. - "`select employeeid, employeename, sum(maxscore) totalscore
from (
select e.id employeeid, e.name employeename, tr.testid , max(tr.score) maxscore
from employees e
join test_results tr
on e.id = tr.employee_id
group by tr.employeeid, tr.testid
order by 1
)
group by 1,2
order by 3 desc`
`"See full answer
"Handling projects out of my expertise:
When faced with a project that falls outside of my expertise, I take the following steps:
Identify my skills and knowledge gaps: I assess my own strengths and limitations, and determine which areas of the project may be outside of my comfort zone or expertise.
Seek guidance and mentorship: I reach out to colleagues or subject matter experts who have relevant knowledge or experience, and ask for their advice and guidance on the project.
Learn and adapt"
Anonymous Flamingo - "Handling projects out of my expertise:
When faced with a project that falls outside of my expertise, I take the following steps:
Identify my skills and knowledge gaps: I assess my own strengths and limitations, and determine which areas of the project may be outside of my comfort zone or expertise.
Seek guidance and mentorship: I reach out to colleagues or subject matter experts who have relevant knowledge or experience, and ask for their advice and guidance on the project.
Learn and adapt"See full answer
"Engineering Managers (EMs) juggle multiple responsibilities, which can vary significantly depending on the company, team, and organizational needs. One of the most critical skills for an EM is strategic thinking. This includes setting a clear vision for the team, participating in roadmap planning meetings, and crafting actionable roadmaps to guide the team toward its goals.
In addition to strategic thinking, an EM must excel in three key areas:
People Management: This involves ensuring te"
Pramod S. - "Engineering Managers (EMs) juggle multiple responsibilities, which can vary significantly depending on the company, team, and organizational needs. One of the most critical skills for an EM is strategic thinking. This includes setting a clear vision for the team, participating in roadmap planning meetings, and crafting actionable roadmaps to guide the team toward its goals.
In addition to strategic thinking, an EM must excel in three key areas:
People Management: This involves ensuring te"See full answer
"User Persona
Individual heavy Users
Casual users
Enterprise Users
Occasional Users
I would like to think more about the Enterprise users, because they are the power users and the maximum revenue of the Google may come up with the enterprise solutions. It is my hypothesis that despite of improvement of the Google drive, common individual users are highly unlikely to use the premium version of the G Suite
User Journey of the person using Google Drive
Want to work on the new document"
Anonymous Muskox - "User Persona
Individual heavy Users
Casual users
Enterprise Users
Occasional Users
I would like to think more about the Enterprise users, because they are the power users and the maximum revenue of the Google may come up with the enterprise solutions. It is my hypothesis that despite of improvement of the Google drive, common individual users are highly unlikely to use the premium version of the G Suite
User Journey of the person using Google Drive
Want to work on the new document"See full answer
Product Manager
Product Design
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"Clarifying Questions
What do we mean by ‘improve’? Is there a certain goal that we are trying to attain?
Is there a target user that we are going for?
Any constraints or things to keep in mind when building this?
Assumptions
Only focused on google docs and not collaboration on other G-suite products such as PPT or sheets
What is Google Docs? Web-based productivity tool that allows you to access your files from any computer through your gmail account. You can also share and"
Esha - "Clarifying Questions
What do we mean by ‘improve’? Is there a certain goal that we are trying to attain?
Is there a target user that we are going for?
Any constraints or things to keep in mind when building this?
Assumptions
Only focused on google docs and not collaboration on other G-suite products such as PPT or sheets
What is Google Docs? Web-based productivity tool that allows you to access your files from any computer through your gmail account. You can also share and"See full answer
"Count items between indices within compartments
compartments are delineated by by: '|'
items are identified by: '*'
input_inventory = "*||||"
inputstartidxs = [1, 4, 6]
inputendidxs = [9, 5, 8]
expected_output = [3, 0, 1]
Explanation:
"*||||"
0123456789... indices
++ + # within compartments
^ start_idx = 1
^ end_idx = 9
-- - # within idxs but not within compartments
"*||||"
0123456789... indices
"
Anonymous Unicorn - "Count items between indices within compartments
compartments are delineated by by: '|'
items are identified by: '*'
input_inventory = "*||||"
inputstartidxs = [1, 4, 6]
inputendidxs = [9, 5, 8]
expected_output = [3, 0, 1]
Explanation:
"*||||"
0123456789... indices
++ + # within compartments
^ start_idx = 1
^ end_idx = 9
-- - # within idxs but not within compartments
"*||||"
0123456789... indices
"See full answer
"Assumptions:
User type: school children living in the USA.
Form factor: mobile app on iOS and Android
Problem statement
School children all across the country visit museums 2-4 times in a year. The museums have info on the contents and layout but that is static.
Key value proposition of product is to guide users through the museum
Internal company assessment
Let's assume the interview is at Google. Google's mission is to organise the world's information so this problem aligns with"
Rahul J. - "Assumptions:
User type: school children living in the USA.
Form factor: mobile app on iOS and Android
Problem statement
School children all across the country visit museums 2-4 times in a year. The museums have info on the contents and layout but that is static.
Key value proposition of product is to guide users through the museum
Internal company assessment
Let's assume the interview is at Google. Google's mission is to organise the world's information so this problem aligns with"See full answer
"Let me first ask some clarification questions / make assumptions:
Any specific geographic region? => USA
How do we measure bandwith?
a. Bandwith is the maximum internet speed required for our google maps servers to support all google maps traffic in the USA.
At which point do we measure bandwith? => at the “entrance” of each google server center
Do we talk about maximum bandwith required?
a. Yes, the maximum BB required to support google maps in the USA (on side of Google)
Outline: O"
Valentin B. - "Let me first ask some clarification questions / make assumptions:
Any specific geographic region? => USA
How do we measure bandwith?
a. Bandwith is the maximum internet speed required for our google maps servers to support all google maps traffic in the USA.
At which point do we measure bandwith? => at the “entrance” of each google server center
Do we talk about maximum bandwith required?
a. Yes, the maximum BB required to support google maps in the USA (on side of Google)
Outline: O"See full answer
"Assumption #1: the deal is signed and the customer now will being the process of moving to GCP
Assumption #2 : the deal includes Iaas as well as Paas (App Engine) - moving apps from on prem to cloud
Objective : Design a product that will help the customer onboard and successfully plan the move to GCP. Customer is using on premise and is new to cloud.
Lets assume the tool should include the roadmap planning too ie decisions such as moving all vs some applications etc . As in any onboarding to"
Aruna D. - "Assumption #1: the deal is signed and the customer now will being the process of moving to GCP
Assumption #2 : the deal includes Iaas as well as Paas (App Engine) - moving apps from on prem to cloud
Objective : Design a product that will help the customer onboard and successfully plan the move to GCP. Customer is using on premise and is new to cloud.
Lets assume the tool should include the roadmap planning too ie decisions such as moving all vs some applications etc . As in any onboarding to"See full answer
"def friend_distance(friends, userA, userB):
step = 0
total_neighs = set()
llen = len(total_neighs)
total_neighs.add(userB)
while len(total_neighs)!=llen:
s = set()
step += 1
llen = len(total_neighs)
for el in total_neighs:
nes = neighbours(friends, userA, el)
if userA in nes:
return step
for p in nes:
s.add(p)
for el in s:
total_neighs.add(el)
return -1
def neighbours(A,n1, n2):
out = set()
for i in range(len(A[n2])):
if An2:
out.add(i)
return out"
Batman X. - "def friend_distance(friends, userA, userB):
step = 0
total_neighs = set()
llen = len(total_neighs)
total_neighs.add(userB)
while len(total_neighs)!=llen:
s = set()
step += 1
llen = len(total_neighs)
for el in total_neighs:
nes = neighbours(friends, userA, el)
if userA in nes:
return step
for p in nes:
s.add(p)
for el in s:
total_neighs.add(el)
return -1
def neighbours(A,n1, n2):
out = set()
for i in range(len(A[n2])):
if An2:
out.add(i)
return out"See full answer
"Proposed Solution: Awareness and Control Features
Algorithm Awareness Campaign Educational Content: Create short videos explaining how the algorithm works to enhance user experience.
Transparency Reports: Regular updates on algorithm changes to keep users informed.
User-Controlled Engagement Settings Customizable Feed Options: Allow users to adjust content preferences and limit certain types of videos.
Time Management Tools: Introduce reminders for screen time limits an"
Jaswanth P. - "Proposed Solution: Awareness and Control Features
Algorithm Awareness Campaign Educational Content: Create short videos explaining how the algorithm works to enhance user experience.
Transparency Reports: Regular updates on algorithm changes to keep users informed.
User-Controlled Engagement Settings Customizable Feed Options: Allow users to adjust content preferences and limit certain types of videos.
Time Management Tools: Introduce reminders for screen time limits an"See full answer
"As a product manager, my first step in designing a free product would be to define the product's target audience and the problem it aims to solve. Once these factors are established, I can then determine the best way to monetize the product.
One way to monetize a free product is through advertising. This involves displaying ads to users as they use the product, and earning revenue based on the number of clicks or impressions the ads receive. This model is commonly used by social media platforms,"
Anonymous Flamingo - "As a product manager, my first step in designing a free product would be to define the product's target audience and the problem it aims to solve. Once these factors are established, I can then determine the best way to monetize the product.
One way to monetize a free product is through advertising. This involves displaying ads to users as they use the product, and earning revenue based on the number of clicks or impressions the ads receive. This model is commonly used by social media platforms,"See full answer
"Clarifying questions:
Will it be a separate app of Google maps or integrated into an existing one? Let's say it will be integrated into an existing app.
Which disabilities users have? Any of your choice.
For which audience are we building this product? Any exact geo, age, gender? Any of your choice.
How many resources we have? Any timeline for the product to be launched? Need to launch a product in a year and any resources required.
Google's mission is to organize the world's"
Maria T. - "Clarifying questions:
Will it be a separate app of Google maps or integrated into an existing one? Let's say it will be integrated into an existing app.
Which disabilities users have? Any of your choice.
For which audience are we building this product? Any exact geo, age, gender? Any of your choice.
How many resources we have? Any timeline for the product to be launched? Need to launch a product in a year and any resources required.
Google's mission is to organize the world's"See full answer
"SELECT pro.id, pro.title, pro.budget, COUNT(employeeid) AS numemployees, SUM(e.salary) as total_salaries
FROM projects pro
JOIN employeesprojects ep ON ep.projectid = pro.id
JOIN employees e ON e.id = ep.employee_id
GROUP BY project_id;
`"
Zacharias E. - "SELECT pro.id, pro.title, pro.budget, COUNT(employeeid) AS numemployees, SUM(e.salary) as total_salaries
FROM projects pro
JOIN employeesprojects ep ON ep.projectid = pro.id
JOIN employees e ON e.id = ep.employee_id
GROUP BY project_id;
`"See full answer
"Statement: Improve the music experience at youtube
Is the goal to improve the experience for any particular kind of user/music genre?
Ans: No, nothing in particular
Goal: I’m going to assume the goal is to improve the experience of listening to music generally
Google’s mission is to organise the world’s information. Youtube is a platform that lets people discover videos, interesting content as tailored to their interests, thus serving Google’s mission
Music on Youtube also contributes to"
Pranav M. - "Statement: Improve the music experience at youtube
Is the goal to improve the experience for any particular kind of user/music genre?
Ans: No, nothing in particular
Goal: I’m going to assume the goal is to improve the experience of listening to music generally
Google’s mission is to organise the world’s information. Youtube is a platform that lets people discover videos, interesting content as tailored to their interests, thus serving Google’s mission
Music on Youtube also contributes to"See full answer