Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!
Welcome to our May SQL Practice! New tasks are waiting for you. If you've finished our Recursive Queries course and have knowledge about CTE in SQL, this is a good way to practice your database skills. Are you ready to start the SQL adventure in this month's SQL Practice?
More and more people have been gathering information about their families. It is a fantastic activity that allows people to learn more about themselves. And using a database is a great way to store family tree information.
Meet Luke, a student who will be presenting information about his family tree. To prepare, he needs to use data from his family tree database.
Will he learn something interesting about his ancestors? How will he organize his ancestors? Which eye color is most common in his family? How long did his ancestors live?
These are some of the questions Luke wants to answer. However, he doesn't know SQL. So, he needs your help. If you've finished our Recursive Queries course, you know everything you need to complete this SQL Practice and help Luke with his project.
Try this SQL Practice to see how you can use SQL with a family tree database. (Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the "Database" tab.)
Let's help Luke learn about his family!