Solution: 27. Most Common Default Languages

Medium

Problem Detail:

Write a SQL query to list languages from default_language ordered by most frequently used.

Answer SQL Query:

SELECT default_language, COUNT(*) AS total_videos
FROM videos
WHERE default_language IS NOT NULL
GROUP BY default_language
ORDER BY total_videos DESC;

You can easily copy this solution, switch back to your editor tab, paste it, and run the SQL!