. If the number of occurrences is the same, the artist's names are sorted in ascending order.

Solution

Method 1 – SQL Group By and Count 1

Intuition

To count how many times each artist appears, we group the Spotify table by artist and count the number of rows for each artist. We then order the results by the count in descending order, and by artist name in ascending order for ties.

Approach

Group the Spotify table by artist.
Count the number of occurrences for each artist.
Order the result by occurrence count descending, then by artist name ascending.

Code

[{"language":"MySQL","code":"SELECT artist, COUNT(*) AS occurrences\nFROM Spotify\nGROUP BY artist\nORDER BY occurrences DESC, artist ASC;","lang":"sql","html":"<pre class=\"shiki shiki-themes github-light github-dark\" style=\"background-color:#fff;--shiki-dark-bg:#24292e;color:#24292e;--shiki-dark:#e1e4e8\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color:#D73A49;--shiki-dark:#F97583\">SELECT</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\"> artist, </span><span style=\"color:#005CC5;--shiki-dark:#79B8FF\">COUNT</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">(</span><span style=\"color:#D73A49;--shiki-dark:#F97583\">*</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">) </span><span style=\"color:#D73A49;--shiki-dark:#F97583\">AS</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\"> occurrences</span></span>\n<span class=\"line\"><span style=\"color:#D73A49;--shiki-dark:#F97583\">FROM</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\"> Spotify</span></span>\n<span class=\"line\"><span style=\"color:#D73A49;--shiki-dark:#F97583\">GROUP BY</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\"> artist</span></span>\n<span class=\"line\"><span style=\"color:#D73A49;--shiki-dark:#F97583\">ORDER BY</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\"> occurrences </span><span style=\"color:#D73A49;--shiki-dark:#F97583\">DESC</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">, artist </span><span style=\"color:#D73A49;--shiki-dark:#F97583\">ASC</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">;</span></span></code></pre>"},{"language":"PostgreSQL","code":"SELECT artist, COUNT(*) AS occurrences\nFROM Spotify\nGROUP BY artist\nORDER BY occurrences DESC, artist ASC;","lang":"sql","html":"<pre class=\"shiki shiki-themes github-light github-dark\" style=\"background-color:#fff;--shiki-dark-bg:#24292e;color:#24292e;--shiki-dark:#e1e4e8\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color:#D73A49;--shiki-dark:#F97583\">SELECT</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\"> artist, </span><span style=\"color:#005CC5;--shiki-dark:#79B8FF\">COUNT</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\">(</span><span style=\"color

Related Tags