SELECT label FROM albums GROUP BY label ORDER BY count(*) DESC LIMIT 1
What is the label that has the most albums?
SELECT label FROM albums GROUP BY label ORDER BY count ( * ) DESC LIMIT 1
select label from albums group by label order by count ( * ) desc limit value
What is the label that has the most albums ?