தமிழில் - Popular Artist on Spotify | SQL Interview | Data Engineer Interview Question | FAANG SQL

Video 254 : This is the 47th video of the SQL Interview Question series.

00:00 - Introduction to dataset and Question
02:45 - Approach 1: Simple Aggregate Function
04:50 - Approach 2: Using Window Functions
06:40 - Approach 3: Correlated Subquery
08:20 - Conclusion

We are given Spotify table where id is the primary key for this table.
Each row contains an id, track_name, and artist.
We are asked to write a solution to find how many times each artist appeared on the Spotify ranking list.

Return the result table having the artist's name along with the corresponding number of occurrences ordered by occurrence count in descending order. If the occurrences are equal, then it’s ordered by the artist’s name in ascending order.

In this video, we are going to discuss three different aproach to address this question

** Approach 1: Simple Aggregate Function **
This method uses a straightforward GROUP BY clause with COUNT() to count the occurrences of each artist. It's efficient and easy to understand.

** Approach 2: Using Window Functions **
Here, we use a window function with COUNT() OVER() to achieve the same result. This approach is more flexible and can be useful in more complex scenarios.

** Approach 3: Correlated Subquery **
This method involves a correlated subquery to count the occurrences for each artist. While it might be less efficient for large datasets, it demonstrates another way to approach the problem.

For a comprehensive understanding of these SQL methodologies and their application, please refer to this explanatory video.

code: https://github.com/jeganpillai/sql_re...

Follow me on,
Website : https://growwithdata.co/
YouTube :    / @growwithdata  
TikTok :   / growwithdata  
LinkedIn :   / growwithdata  
Facebook :   / growwithdata.co  
FB Group : facebook.com/groups/datainterviewpreparation
twitter :   / growwithdata_co  
Instagram :   / growwithdata.co  
WhatsApp : https://whatsapp.com/channel/0029VaF8...
TheWide : https://thewide.com/profile/891

#sql #dataengineers #tablejoins #ceil #floor #bucket #meta #google #facebook #apple #paypal #netflix #amazon #deinterview #sqlinterview #interviewquestions #leetcode #faang #maanga #mysql #oracle #dbms #query #sqlserver #mysql #coderpad #aggregates #aggregation #nonaggregation #database #placementpreparation #lead #lag #windowsfunction #nullcheck #coalesce #sqlperformance #ifnull #case #lead #lag #windowsfunction #tamil #tamilpython #tamilinterview #tamilinterviewlatest #tamilinterviewquestions #sqlintamil