Scalar Subquery in SELECT

Use a scalar subquery in the SELECT clause to add computed values. Show each artist alongside the total number of artists in the database.

Write a query that shows each artist name with the total artist count as a reference.

Schema: Artist

Requirements:

• Return artist Name
• Use a scalar subquery to add TotalArtists (count of all artists)
• Limit to 10 rows

Scalar Subquery in SELECT:

SELECT column, (SELECT COUNT(*) FROM table) AS Total FROM table;