Exercise: LIKE and Pattern Matching
Last Updated: May 10, 2026
For this exercise, we will work with below data:
Exercise 1
Find all artists whose name starts with "The " (with the space). Show the name column, ordered alphabetically.
Expected Query
Expected Output
Exercise 2
Find all users whose email ends with @gmail.com. Show username and email, ordered by username.
Expected Query
Expected Output
Exercise 3
Find all artists whose name does NOT start with "The ". Show the name column, ordered alphabetically.
Expected Query
Expected Output
Exercise 4
Find all tracks whose title contains "night" case-insensitively. Show title and duration_seconds, ordered by title.
Expected Query
Expected Output
Exercise 5
Find all users whose username contains a literal underscore. Show username and email, ordered by username.
Expected Query
Expected Output
Exercise 6
Find all tracks whose title is exactly two words (contains exactly one space). Show the title, ordered alphabetically.
Expected Query
Expected Output
Exercise 7
Find all users whose username contains at least one digit. Show username and email, ordered by username.
Expected Query
Expected Output
Exercise 8
Find all artists whose name contains either "Wave" or "Spark", but NOT both. Show the name, ordered alphabetically.
Expected Query
Expected Output
Exercise 9
Find all users whose email domain ends in .com (case-insensitive) AND whose username contains a literal underscore followed by a digit. Show username and email, ordered by username.