This project focuses on analyzing data from the WORLD database, which includes three key tables: city, country, and countrylanguage. The aim is to gain insights into global demographics, language distribution, and regional characteristics. We utilize Python, Pandas, and MySQL to query and analyze the data, showcasing various including:
- SQL operations
- stored procedures
- Views.
The database consists of the following tables:
city: Contains information about cities, including their names, country codes, districts, and populations. country: Provides details about countries, such as codes, names, continents, regions, surface areas, populations, and government forms. countrylanguage: Offers information on languages spoken in countries, including whether they are official and the percentage of speakers.
Here are all the sql queries used:
To clone the repo, use the following:
git clone https://github.com/franciskyalo/sql_queries.git
Ensure you have python version greater than 3.8
To Create a virtual enviroment:
python -m venv newenviroment
To activate the enviroment use:
.\venv\Scripts\activate
