Leetcode Problem 2669. Count Artist Occurrences On Spotify Ranking List

2669. Count Artist Occurrences On Spotify Ranking List

Leetcode Solutions

Select the artist column from the Spotify table.
Use the COUNT() function to count the number of occurrences of each artist's tracks.
Group the results by the artist column using the GROUP BY clause.
Order the results by the count of occurrences in descending order using the ORDER BY clause.
For artists with the same number of occurrences, order by the artist's name in ascending order.
Return the artist names along with their corresponding number of occurrences.


erDiagram
    Spotify {
        int id PK
        varchar track_name
        varchar artist
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen