Interview Questions

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

Ana A. - "Amazon: Mission: to be Earth's most customer-centric company Insight: Quick delivery and Great Customer Care are the key value prep of AP. Vision: To be earth's most customer-centric company; to build a place where people can come to find and discover anything they might want to buy online. Strengths: Personalization Wide User Base + Wide Seller Base Own delivery fleet (planes, trucks etc) How they make Money: Sellers Commission "See full answer

Temesgen B. - "Very Good Explanation Thanks For This Rely Good Explanation"See full answer

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

Jaime A. - "I would avoid converting order_date WITH monthly_totals AS ( SELECT department_id, SUM(CASE WHEN DATETRUNC('month', orderdate) = '2022-11-01' THEN orderamount ELSE 0 END) AS novtotal, SUM(CASE WHEN DATETRUNC('month', orderdate) = '2022-12-01' THEN orderamount ELSE 0 END) AS dectotal FROM orders WHERE order_date BETWEEN '2022-11-01' AND '2022-12-31' GROUP BY department_id ), mom_increases AS ( SELECT "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

Mohit C. - "-- LTV = Sum of all purchases made by that user -- order the results by desc on LTV select u.user_id, sum(a.purchase_value) as LTV from user_sessions u join attribution a on u.sessionid = a.sessionid group by u.user_id order by sum(a.purchase_value) desc"See full answer

Ben C. - "The suggested solution is with Joins. It works but it joins two full tables and then filters the result. A more efficient approach is using a subquery or CTE to find the top customer through the transactions table and then get the customer name using join or subquery which will only look for 1 record in the users table. Most efficient (CTE + JOIN): with top_customer as ( select t.user_id, count(*) as orders from transactions t group by t.user_id order by o"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

Derrick M. - "SELECT o.order_amount FROM orders o JOIN departments d ON d.departmentid = o.departmentid WHERE d.department_name = 'Fashion' ORDER BY order_amount DESC LIMIT 1 OFFSET 1; `"See full answer

Akash G. - "Select count(DISTINCT a.customerid) as customers, b.departmentname from orders a left join departments b on a.departmentid = b.departmentid where strftime('%Y', a.order_date) = '2022' and (b.department_name like ('%fashion%') or b.department_name like ('%electronics%')) group by b.department_name;"See full answer

Prajwal M. - "select d.departmentname, sum(o.orderamount) as total_revenue from orders as o join departments as d on o.departmentid=d.departmentid where o.orderdate>= currentdate - interval '12 months' group by d.department_name order by total_revenue desc;"See full answer

Gabriella F. - "Table user is empy....... Problem with this problem "See full answer