Search Artists by Name Pattern

A customer is looking for bands that start with "The" (like "The Beatles", "The Rolling Stones", etc.). You need to search the artist catalog for matching names.

Write a SQL query to find all artists whose Name starts with the word 'The'. Return only the artist names.

Schema: Artist

Requirements:

• Find artists where Name starts with 'The'
• Use pattern matching (LIKE operator)
• Return only the Name column

Hint about LIKE:

The LIKE operator uses wildcards: % matches any sequence of characters, _ matches any single character.