Interview Questions

PTL - "Clarify the default pick up location/pin feature - I'm assuming it lets you define a location in settings that is used for pickups unless you over ride it. this is a rider feature. It is not used by the driver to specify where they want to pick up riders Feature goal Make it simpler for the user to book a ride as they no longer need to type in an address when going to the default location User Journey assuming they have already set the default location they open the app cl"See full answer

Arya R. - "I'm going to assume the problem is limited until the point of where the rider get into the car. Rider segments/characteristics: Local rider (lives and travels in the same city) Tourist rider (visiting a city, using Lyft for the first time in the city) Lets think about some problems for these types of users: Local rider: (Choose to prioritize on these use-cases assuming its a larger % of rides overall) Ride shows as confirmed, but driver does not move on the map Driver does"See full answer

Tracy C. - "Before I walk you through my thought process, I want to align you with the definition of discovery. I assume discovery is the journey before a guest adds a property or experience to the cart, which can be broken down into the discovery of listings pre-search bar on the homepage and discovery post-search bar on the search results page. Are we talking about both touch points as discovery, or would you like me to focus specifically on one? Is this for a specific platform, mobile or desktop web? Bec"See full answer

Anonymous Minnow - "Goals (Prod & Safeway) User Groups: Shoppers: College Students Professionals Families Elderly New customers (not already in the store) I selected elderly due to trends on the aging population being a significant population in the next decade and it being a group we have the most opportunity as Safeway to support. Pain Points **Most likely these customers are buying things in person or someone is purchasing items for them and gettin"See full answer

Luke P. - "A full stack developer could be summarized as the person who both writes the APIs and consumes the APIs. They are familiar with Databases/Data-layer services, middle-layer/application services and business logic, and finally familiar with the consumers whether front-end applications/UIs or other systems. They can understand the trade-offs up and down the stack, where to adjust along the service-call-path. Ideally they are comfortable programming both async calls (front end javascript promises, e"See full answer

Arasu raja B. - "Amazon price tracker tools like Aarabuy function by monitoring the prices of products listed on Amazon and notifying users when prices drop or reach a desired level. Here's a detailed look at how these tools generally work: Data Collection Web Scraping: Price trackers use web scraping techniques to extract product prices from Amazon's website. They periodically visit product pages to collect current prices. Amazon API: Some tools may use the Amazon Product Advertising API, which provides pro"See full answer

Aekagra S. - "To answer this let's deconstruct what Amazon Prime offers Free Delivery on Amazon Same-day delivery for a few locations Additional discounts Early Access & Exclusive Deals Prime video subscription Prime music subscription Considering above let's first talk about music and video subscription Netflix, Disney, and other OTT platforms on average charge ₹120/month. Now for Music, Spotify or YT music charges an average of ₹180/month for their premium subscription. Coming the E-com"See full answer

Raj V. - "CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·"See full answer

Steven S. - "too many questions for clarification on this to start"See full answer

Anonymous Wombat - "with cte as ( select a.departmentid departmentid , b.departmentname departmentname , extract(month from a.order_date) mm , sum(a.orderamount) currentval , lag(sum(a.order_amount)) over(partition by a.departmentid order by extract(month from a.orderdate)) previous_val from orders a inner join departments b on a.departmentid=b.departmentid where extract(year from a.order_date) = 2022 and extract(month from a.order_date) in (11,12) group by 1,2,3 ) select departmentid, departmentname, c"See full answer

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

Jaime A. - "I might be missing something but the solution, seems to be incorrect. ... , post_pairings AS ( SELECT ps.user_id, ps.postseqid AS failpostid, ps.postseqid + 1 AS nextpostid FROM post_seq AS ps WHERE ps.issuccessfulpost IS TRUE ) -- here ps.issuccessfulpost IS TRUE the condition should be FALSE -- in that way ps.postseqid is the actual failed post(failpostid) -- Additionally, at the end the join is assumming that the sequence id is going to match the post_id, wh"See full answer

Aneesha K. - "-- Write your query here select u.userid as userid, IFNULL(sum(purchase_value), 0) AS LTV FROM user_sessions u JOIN attribution a ON u.sessionid = a.sessionid group by user_id order by LTV desc ; Needs a full join. Wondering why cant we do a left outer join here. All the sessions should have complete data."See full answer

מאיה ט. - "select t.user_id, u.name, count(t.id) as orders from transactions t inner join users u on t.user_id=u.id group by 1,2 order by count(t.id) desc limit 1"See full answer

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

Alina G. - "Order the result in descending month is not applied in the solution"See full answer

G B. - " select user_id, b.marketing_channel from user_sessions a Left join attribution b on b.sessionid = a.sessionid group by 1,2 HAVING sum(purchasevalue)>100 and min(adclick_timestamp) `"See full answer

Shriganesh K. - "not sure what's wrong here> select a.marketing_channel, avg(purchasevalue) as avgpurchase_value, sum(case when a.purchasevalue > 0 then 1 else 0 end) * 1.0 /count(a.sessionid) as conversion_rate from attribution a left join usersessions u on a.sessionid = u.session_id group by a.marketing_channel order by conversion_rate desc `"See full answer