LeetCode 1795 Interview SQL Question with Detailed Explanation | Practice SQL

Показать описание

In this video I solve and explain a leetcode SQL question using MySQL query. This question has been asked in Apple, Facebook, Amazon, Google, Adobe, Microsoft, Adobe interviews or what we popularly call FAANG interviews.
I explain the related concept as well. This question includes points to keep in mind to develop SQL queries.

LeetCode is the best platform to help you enhance your skills, expand your knowledge and prepare for technical interviews.

If you found this helpful, Like and Subscribe to the channel for more content.

#LeetCodeSQL #FAANG #SQLinterviewQuestions

Рекомендации по теме

Комментарии

Its very helpful for by step explanation is great..thanku

sathiroy

very beautiful explaination... Thank you :)

ajlalkhan

it was really helpful thanks for uploading...

alphonseprakash

This question is listed as easy on LeetCode even tho it was asked in Amazon ? hehe something doesnt sound right, i completly didint understand how to complete this one and even when i looked up the solutions i was confused why was store1 in a string but u explain everything, you are awesome, i will come back to this video coz im still not a 100% on this one

DisturbeD

with cte as ( select product_id, store, price from ( SELECT product_id, store1, store2, store3 FROM Products) AS product_i
UNPIVOT
(Price FOR Store IN
(store1, store2, store3)) AS Sales)

select product_id, store, price from cte where price is not null

shashankreddy

my way which works but isn't ideal to do this way:
select * from
(with cte as(
SELECT * FROM products
CROSS JOIN
( SELECT 'store1' AS name, 1 as ranks UNION ALL SELECT 'store2', 2 UNION ALL SELECT 'store3', 3 )
AS temp)
select product_id, name as store, case when ranks=1 then store1 when ranks=2 then store2 else store3 end
as price from cte) x
where x.price is not null;

mickyman

is it the best way to solve this question?

atishay-jain

LeetCode 1795 Interview SQL Question with Detailed Explanation | Practice SQL

LeetCode 1795 Interview SQL Question with Detailed Explanation | Practice SQL

1795. Rearrange Products Table | LeetCode | SQL | Solution | Interview Problem

MLV Prasad - LeetCode SQL [ EASY ] | 1795 | 'Rearrange Products Table' |

SQL Skills That Sell: Prep for High-Paying Job Interviews! - Data Science | Leetcode 1795

LeetCode 1795 | Rearrange Products Table | Union all | SQL

【Leetcode Pandas 10/30】1795. Rearrange Products Table (~Easy) df.melt for converting wide into long~...

LeetCode 1303 Interview SQL Question with Detailed Explanation | Practice SQL | Window Functions

MLV Prasad - LeetCode SQL [ EASY ] | 1693 | 'Daily Leads and Partners' |

LeetCode Medium 1596 Amazon Interview SQL Question with Detailed Explanation

MLV Prasad - LeetCode SQL [ EASY ] | 1873 | 'Calculate Special Bonus' |

1693. Daily Leads And Partners | LeetCode | SQL | Solution | Interview Problem

Rearrange Products Table (Leetcode 1795) in Telugu

MLV Prasad - LeetCode SQL [ EASY ] | 1757 | 'Recyclable and Low Fat Products' |

Solving LeetCode problem 1795 in APL (Rearrange Products Table)

Leetcode SQL Challenge Day 4 | SQL Interview Questions | Leetcode SQL Interview Queries Solved #sql

MLV Prasad - LeetCode SQL [ EASY ] | 1511 | 'Customer Order Frequency' |

1587. Bank Account Summary 2 | LeetCode | SQL | Solution | Interview Problem

1741. Find Total Time Spent By Each Employee | LeetCode | SQL | Solution | Interview Problem

LeetCode Interview SQL Question with Detailed Explanation | Practice SQL | LeetCode 613

LeetCode 178 (Rank Score) SQL questions explained in 3 mins!

1667. Fix Names in a Table leetcode solution | leetcode sql solutions

LeetCode SQL Study Plan || Rearrange Products Table || Unpivot in SQL

MLV Prasad - LeetCode SQL [ EASY ] | 1322 | 'Ads Performance' |

LeetCode 1667 | Fix Names in a Table | Concat | Substring | Upper | Lower | Length | SQL