10% Monthly Sales Increase - Amazon Interview Question - SQL
HTML-код
- Опубликовано: 6 сен 2024
- You have been asked to compare sales of the current month, May, to those of the previous month, April.
The company requested that you only display products whose sales (UNITS SOLD * PRICE) have increased by more than 10% from the previous month to the current month.
Your output should include the product id and the percentage growth in sales.
Companies appeared in: Amazon
Difficulty: Medium
Ideas: SQL Window Functions (LAG), Common Table Expressions (CTE), GROUP BY
Problem: t.ly/VvntN
Very helpful for various sales companies 👍🙏
Very helpful video 👍👌
Thanks for sharing this info ❤
Any time!