Product Sales Analysis I | Leetcode 1068 | Crack SQL Interviews in 50 Qs #mysql #leetcode

Want to crack SQL interviews? Check out our latest video!!!

A 50-questions SQL study plan to ace any interview.
This tutorial will walk you through the solution in easy steps. This is an easy-level question from Leetcode.

Consistency is what transforms average into excellence.
So be consistent & keep Coding💻!!

Timecodes
0:00 - Introduction
0:14 - Question Explanation
1:09 - Understanding Concept with the help of Example
2:40 - Writing SQL Query
4:43 - Explanation of the Query
6:12 - Outro

Connect With Me -

#coding
#leetcode
#mysql
#sql
#interview
#sqlinterview
#sqlinterviewquestionsandanswers
#sql_server
#article
#learnwithchirag
#productivity
#sales
#google
#microsoft
#amazon
#googleinterview

[learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on


Instagram Handles :-



Let's stay connected and keep the creativity flowing! 💡

[nimbu_]

Great Explaination! Joins is too important, most companies asks this topic.

[nihalnandannayak]

Insted of using left join here we can do inner join also, ,

select p.product_name, s.year, s.price from Sales as s inner join Product as p on s.product_id = p.product_id ;

[no]

this can also be done by right joins right

[laxmansingh]

sir maine bhi same hi kra hai
but when I'm submitting this solution, so, error occur "exceed time limit"
what should I do ?

[bitsandvibes-uu]

SELECT p.product_name, s.year, s.price
FROM sales s
LEFT JOIN products p
ON s.product_id = p.product_id