This sample data delves into the core of our personal data concierge by exploring four simple interconnected tables: Cities, Courses, Enrollments, and Students.

By the end of this interaction with our concierge, you’ll gain a deeper understanding of how these tables work together to paint a picture of students, their learning paths, and the locations where it all unfolds. To take a look at the MySQL schema of the following tables, download the schema here. Please keep in mind that UnSQL is still in beta and there’s a possibility that the concierge may glitch.

Here’s a list of a few questions to ask and better understand how the concierge works:

• Which courses have the highest enrollment rates?
• What is the completion rate of each course, and how does it vary by city?

• Is there a student named Emily? If yes, what courses is she taking?

• What are the common characteristics of students who successfully complete their courses?
• Out of Jane Smith and Emily Johnson, who completed their course?

Below is a demo video of both the personal concierge and the WhatsApp integration, as well as an excerpt of these tables for reference.