SQL Basics

Where In The World Is Carmen Sandiego?

We're going to use what we've already learned about searching with SQL commands and apply it to chase down and capture an elusive and world-renowned thief: Carmen Sandiego. Follow the clues, use the interweb, write down both the SQL commands/queries you used and your answers to the clues, and figure out where Carmen is headed so we can catch her.

Setup

• Fork and clone this repo.
• Go inside the folder you just cloned
• From your terminal we will create a database called carmen and populate it with the data found in world.sql. The only thing you have to do is to run the command in your terminal.

$: psql -f world.sql

You should see something like this. 👇

Now your database is ready!!!! good luck detective 🔍

Exercise

• On the file find_carmen.sql use the clues to create the appropriate SQL queries to help you find Carmen. Tell us where she's heading!
• You can run your queries on the terminal or in pgAdmin, just save the final query to the file and move to the next clue.
• For each clue solved do a commit 😉
• Create a pull request to submit your work.

Additional Resources

• PostgreSQL tutorial
• PostgreSQL official documentation

License

1. All content is licensed under a CC­BY­NC­SA 4.0 license.
2. All software code is licensed under GNU GPLv3. For commercial use or alternative licensing, please contact legal@ga.co.