LeetCode Question · Apr 2022

Amazon BIE L5

4 upvotes 735 views 2 replies

Question Details

Revenue: customer_id (varchar), product_id (varchar), month_start_date (date), 2022-03-01 revenue_amt (decimal) 1. Display the top 10 revenue generating products for year 2020. select top 10 product_id , sum(revenue_amt) as total from Revenue where year(month_start_date) = 2020 group by product_id order...

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) reported in 2022.

It covers the following topics: Sql .

Topics