UNION: Combine Artists and Genres

Use UNION to combine different types of names into a single list. Create a unified list of both artist names and genre names.

Write a query using UNION to combine artist and genre names into one list.

Schema: Artist

Schema: Genre

Requirements:

• Select artist names with Type = 'Artist'
• UNION with genre names with Type = 'Genre'
• Return Name and Type columns
• Order by Type, then Name
• Limit to 20 rows

UNION Notes:

• UNION removes duplicates
• UNION ALL keeps duplicates (faster)
• Column names come from the first SELECT