In this guide, we'll use data table and SQL cells to explore the database used to solve the SQL murder mystery. No worries, we won't spoil the ending here, but perhaps you can solve it after you're done with this guide.

We have imported the database as a DuckDB database into this notebook. DuckDB is a very powerful database that runs inside your browser. We can use it just like any external database you might connect to, such as MySQL, Snowflake, etc.

The mystery begins by explaining that all the information is contained in a database, and that we're looking for the clues on a murder that occurred sometime on January 15, 2018 in SQL City.

We'll create a data table view of the crime_scene_report table and look for murders occurring on that date in that city. We can filter the date to 2018-01-15 (dates in this database are strings), the city to SQL City, and the type to murder.