"Clarifications ( Assuming this a technical question )
What is the purpose of this News feed ?
Do we have a specific platform in mind ( Assumed Android phones )
Focus user group - People who use News feed a lot
Business goal - Provide fresh and engaging content.
Basic functionalities of news feed:
News feed - A space where articles is collated and presented to the user
Organise content.
Customise news feed based on reading patterns.
Push down older content.
Keep the reader"
Uttam R. - "Clarifications ( Assuming this a technical question )
What is the purpose of this News feed ?
Do we have a specific platform in mind ( Assumed Android phones )
Focus user group - People who use News feed a lot
Business goal - Provide fresh and engaging content.
Basic functionalities of news feed:
News feed - A space where articles is collated and presented to the user
Organise content.
Customise news feed based on reading patterns.
Push down older content.
Keep the reader"See full answer
"Clarifying Questions: What's the goal of this feature? I am assuming the goal is to improve the experience.
2) Are we focused on any specific brand? Tesla, Waymo? - I am assuming in general
3) Market - US
4) For the purpose of this question, I am assuming elf-driving cars are fully safe/autonomous and doesn't need any attention from the users to reach from point A to B.
Revised problem statement - Design a feature for self-driving cars to improve the experience.
User-segments: People who use i"
Ashvini B. - "Clarifying Questions: What's the goal of this feature? I am assuming the goal is to improve the experience.
2) Are we focused on any specific brand? Tesla, Waymo? - I am assuming in general
3) Market - US
4) For the purpose of this question, I am assuming elf-driving cars are fully safe/autonomous and doesn't need any attention from the users to reach from point A to B.
Revised problem statement - Design a feature for self-driving cars to improve the experience.
User-segments: People who use i"See full answer
"Assumptions:
Table name : "Table"
02 columns ("City" and "Distance")
"City" column contains distinct variables
No "Null" values in Table
SELECT City, AVG(Distance) AS Avg_distance
FROM (
SELECT
City,
Distance,
ROW NUMBER() OVER (
PARTITION BY City
ORDER BY Distance ASC ) RowAsc ,
ROW NUMBER() OVER (
PARTITION BY City
ORDER BY Distance DESC ) RowDesc
FROM Table
) x
WHERE RowAsc IN (RowDesc, RowDesc - 1, RowDesc + 1)
GROUP BY City
ORDER BY City ;"
Anna H. - "Assumptions:
Table name : "Table"
02 columns ("City" and "Distance")
"City" column contains distinct variables
No "Null" values in Table
SELECT City, AVG(Distance) AS Avg_distance
FROM (
SELECT
City,
Distance,
ROW NUMBER() OVER (
PARTITION BY City
ORDER BY Distance ASC ) RowAsc ,
ROW NUMBER() OVER (
PARTITION BY City
ORDER BY Distance DESC ) RowDesc
FROM Table
) x
WHERE RowAsc IN (RowDesc, RowDesc - 1, RowDesc + 1)
GROUP BY City
ORDER BY City ;"See full answer
"brand keeps promises continuously and consistently. so people belives brands.so it becomes loyal and repeating customers.so i want to become a brand driver who is improving corevalue and marketing value.brand means trust,design,value,strategy,logo,maketing,advertising,identity"
Sri M. - "brand keeps promises continuously and consistently. so people belives brands.so it becomes loyal and repeating customers.so i want to become a brand driver who is improving corevalue and marketing value.brand means trust,design,value,strategy,logo,maketing,advertising,identity"See full answer