Bite 5: Connect to a SQL dataset and query the tables

In this Bite we are going to learn:

1. Connect to a SQLite database
2. Drop a table
3. Query tables
4. Convert them to a Pandas dataframe

Practice the basics first

Jupyter Lab notebook available here when the video gets released on YouTube.

The challenge

The final output of this bite is the small program below.

The solution