Solving AMAZON Toughest SQL Data Science Interview Question - Maximize Prime Item Inventory

If you are preparing for a job interview in data science or data analytics, then this video is for you!

In this video, we'll walk you through a real SQL question that was asked in a #amazon interview. You'll learn how to approach the problem step-by-step, and we'll show you the most effective SQL techniques to solve it. We'll also explain why each step is important and how it contributes to the final solution.

I will guide you through this problem and help you understand the reasoning behind each SQL query. You'll learn how to analyze complex data, identify patterns, and optimize SQL queries for performance.

By the end of this video, you'll have a solid understanding of how to solve similar SQL problems and feel confident in your ability to tackle data science interviews.

Don't forget to like, share, and subscribe to our channel for more exciting data science videos and tutorials. Let's dive in and solve this Google Data Science SQL interview question together!

DataLemur #sql #datascienceinterview

[viviangong]

Can’t understand the context of this question. It’s very confusing… so it’s very easy to NOT understand by using * num_item. Can you explain with details on context of this question if you know?

[zop]

When I run this query to return prime_eligible items that can be stored

[zop]

Pls I'm confused

How many tables did you create

[Mr_travellerrr]

@everydaydatascience plz solve 8week sql study challenge plz

[james-r]

"Non-prime items must always be available in stock to meet customer demand, so the non-prime item count should never be zero" where do you have a check for this?? what if all prime items itself occupy sq feet

[MdRizwan-uudv]

Can you help me to find my mistake in this query?
i am getting the count of not_prime items is 0
please help me to rectify the issue.

WITH cte AS
(SELECT item_type,
COUNT(item_id) number_of_items_in_container,
SUM(square_footage) area_occupied_by_container
FROM inventory
GROUP BY item_type)

SELECT item_type,
AS item_count
FROM cte WHERE item_type='prime_eligible'
UNION
SELECT item_type,

FROM cte WHERE item_type
FROM cte WHERE item_type ='not_prime'