Developed advanced SQL queries to analyze user song listening data within a database The project include. d

Using the ROW_NUMBER() function to rank users based on the number of distinct songs they listened to, grouping by user and ordering them in descending order of diversity.

Building a query to extract detailed session information for each user, identifying the current song and the next song within the same session using the LEAD() function, ordered by timestamp.

Setting a default value of "No Next" when there is no following song in the session.

Organizing and displaying the results ordered by user ID, session ID, and timestamp.

These queries were designed to provide clear insights into user behavior across different sessions and to track the sequence of song plays .