LeetCode Question · Jan 2022 · New York

Amazon (L5 BIE)| Phone screen | SQL/Database Questions + Analytical

SWE Phone Screen Senior
1 upvote 1,355 views 11 replies

Question Details

Question 1: You have first two columns in the below table, how do you display the third column like shown below Table1: dw_run_date units Rolling_3_day_demand 4/20/2020 0:00 10 10 4/21/2020 0:00 20 30 4/22/2020 0:00 30 60 4/23/2020 0:00 40 90 4/24/2020 0:00 50 120 4/25/2020 0:00 60 150 4/26/2020 0:00 70 180 4/27/2020 0:00 80 210 4/28/2020 0:00 90 240 4/29/2020 0:00 100 270 4/30/2020...

Full Details

🔒

Unlock all Amazon questions

Full insider details, leaked discussions, and candidate experiences.

or every company, $100/year →

About This Question

This is a reported interview question from a amazon interview for a swe role (senior level) during the phone screen round reported in 2022.

It covers the following topics: Probability Stats, Sql .