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

I’m currently working through the career path for Data Science. I’m a little confused as to how I’m supposed to know that a birthday column is also a TEXT column. The hint under problem 2 tells me to notice that it is a TEXT column in the table schema. But I don’t see/understand how I should know that. I thought it would be an integer since they’re numbers. Or am I mistaken in that regard because it has hyphens in it?

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

@css6216973739, welcome to the forums!

As soon as you run a SQL query on Codecademy, a Database Schema will appear on the right hand side of the screen. This is where you would notice that birthday is a TEXT column:
image

Thank you! I wasn’t scrolling far enough down to see the Schema and simply clicking the hyperlink in the question.