"Anonymity breeds honest & trustworthy responses. Readers find this relatable and feel motivated to share their story - which kicks off the UGC flywheel."
Prashant B. - "Anonymity breeds honest & trustworthy responses. Readers find this relatable and feel motivated to share their story - which kicks off the UGC flywheel."See full answer
"Swiggy could implement to increase the average order value (AOV) on its platform:
1. Smart Recommendations and Upselling:
Personalized suggestions: Leverage data to recommend items based on past orders, popular choices, and trending items in the user's area.
Upselling prompts: When a user adds an item to their cart, suggest related or higher-value items (e.g., "Would you like to add a side of fries with that?" or "Upgrade to a large for just ₹X more").
Bundle deals: Offer c"
Harish K. - "Swiggy could implement to increase the average order value (AOV) on its platform:
1. Smart Recommendations and Upselling:
Personalized suggestions: Leverage data to recommend items based on past orders, popular choices, and trending items in the user's area.
Upselling prompts: When a user adds an item to their cart, suggest related or higher-value items (e.g., "Would you like to add a side of fries with that?" or "Upgrade to a large for just ₹X more").
Bundle deals: Offer c"See full answer
"Test case is wrong. It expects to sort in asc order of month_year.
-- Write your query here
SELECT
strftime('%Y-%m', createdat) AS monthyear,
COUNT(DISTINCT userid) AS numcustomers,
COUNT(t.id) AS num_orders,
SUM(price * quantity) AS order_amt
FROM
transactions t
INNER JOIN products p
ON t.product_id = p.id
GROUP BY
month_year
ORDER BY
month_year
;
"
Aneesha K. - "Test case is wrong. It expects to sort in asc order of month_year.
-- Write your query here
SELECT
strftime('%Y-%m', createdat) AS monthyear,
COUNT(DISTINCT userid) AS numcustomers,
COUNT(t.id) AS num_orders,
SUM(price * quantity) AS order_amt
FROM
transactions t
INNER JOIN products p
ON t.product_id = p.id
GROUP BY
month_year
ORDER BY
month_year
;
"See full answer
"Asked clarifying questions, this was similar to box. Took a minute to gather thoughts. Came up with a structured approach. Focused on use cases, prioritized it. They wanted to focus on security aspects, MFA, simultaneous read/write operations, etc."
Shahid K. - "Asked clarifying questions, this was similar to box. Took a minute to gather thoughts. Came up with a structured approach. Focused on use cases, prioritized it. They wanted to focus on security aspects, MFA, simultaneous read/write operations, etc."See full answer
"I would ask/investigate the following:
Is this our core competancy of our company
How long would it take to develop it in house and how much would it cost
what will be the time to market of this feature or service when developed in house
what is long term vision of this solution - do we expect that this will grow into becoming a major revenue stream for the company in future and the future of the company will be tied to it?
What is our track record as a company building such a sol"
Nitesh N. - "I would ask/investigate the following:
Is this our core competancy of our company
How long would it take to develop it in house and how much would it cost
what will be the time to market of this feature or service when developed in house
what is long term vision of this solution - do we expect that this will grow into becoming a major revenue stream for the company in future and the future of the company will be tied to it?
What is our track record as a company building such a sol"See full answer
"My extreme collaboration and partnership with stakeholder teams and making sure everyone in the team understands why we are building or shipping a product to customers , I strongly believe that ensuring my development team understands the "WHY" behind work and what value it provides to our customers."
Swathi G. - "My extreme collaboration and partnership with stakeholder teams and making sure everyone in the team understands why we are building or shipping a product to customers , I strongly believe that ensuring my development team understands the "WHY" behind work and what value it provides to our customers."See full answer