Solving Murder Mystery using SQL

Inspiration

Learning SQL concepts

What it does

Uses SQL statements to analyse the data

How we built it

Using Python libraries such as,

• Numpy
• Pandas
• Sqlite3

Challenges we ran into

Trying to connect the database and running queries to execute

Accomplishments that we're proud of

Found a new way to learn SQL programming without installing SQL.

What we learned

• Finding the sql database, here from Kaggle
• Using jupyter notebook to connect to database and execute SQL queries (Google Colab)
• Writing SQL queries
  • Understanding SQL syntax and queries
  • Retrieving data using SELECT statements
  • Sorting and filtering data with ORDER BY and WHERE clauses
  • Using basic functions (e.g., COUNT, SUM, AVG, MAX, MIN)
  • Introduction to JOINs
  • Using aliases for table names
  • Combining multiple tables in queries

Built With

• jupyternotebook
• numpy
• pandas
• python
• sql
• sqlite