Simple Questions Regarding RPA Customer Segmentation


#1

I have a question about one of the questions in the RPA customer segmentation project.
For this question:

The marketing department wants to send a Born in the '80s email to the appropriate users.

Find the email addresses and birthdays of users whose birthday is between 1980-01-01 and 1989-12-31.

My first instinct was to write this code:

SELECT email, birthday
FROM users
WHERE birthday LIKE ‘198%’;

But the assignment says the answer is something like this:

SELECT email, birthday
FROM users
WHERE birthday >= ‘1980-01-01’
AND birthday <= ‘1989-12-31’;

Is there a fundamental difference between these two? The tables returned look identical to me. I don’t really get what the point of writing the code the way it is given is. I would really appreciate the insight into why the given answer was given, considering it seems a lot more convoluted than my answer, and kind of unintuitive.

https://www.codecademy.com/paths/data-science/tracks/sql-basics/modules/dspath-sql-projects-and-applications/projects/user-segmentation-prj